[Home] [Help]
53:
54: -- Initialize API return status to SUCCESS
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: SELECT COUNT(1) INTO l_count FROM AMW_FIN_PROCESS_FLAT
58: WHERE PARENT_PROCESS_ID = P_PROCESS_ID
59: AND ORGANIZATION_ID = P_ORGANIZATION_ID
60: AND FIN_CERTIFICATION_ID = P_CERTIFICATION_ID;
61:
62: --process directly associates to the account which belongs to this financial statement
63: -- to simplify the query, try amw_org_hierarchy_denorm
64: IF(l_count = 0 or l_count is null) THEN
65: IF p_account_process_flag = 'Y' THEN
66: INSERT INTO AMW_FIN_PROCESS_FLAT
67: (
68: FIN_CERTIFICATION_ID,
69: PARENT_PROCESS_ID,
70: CHILD_PROCESS_ID,
83: and process_id = P_PROCESS_ID
84: and (up_down_ind = 'D'
85: or (parent_child_id = -2 and up_down_ind= 'U'));
86: ELSE
87: INSERT INTO AMW_FIN_PROCESS_FLAT
88: (
89: FIN_CERTIFICATION_ID,
90: PARENT_PROCESS_ID,
91: CHILD_PROCESS_ID,
112: -- to be deleted because it's a less efficient solution
113: -- Note: select p_process_id is very important. it's different from select parent_id
114: /*
115: IF p_account_process_flag = 'Y' THEN
116: INSERT INTO AMW_FIN_PROCESS_FLAT
117: (CERTIFICATION_ID,
118: PARENT_PROCESS_ID,
119: CHILD_PROCESS_ID,
120: ORGANIZATION_ID)
127: UNION ALL
128: SELECT P_CERTIFICATION_ID, P_PROCESS_ID, -1, P_ORGANIZATION_ID FROM DUAL);
129: -- sub processes of the process which directly links to the account
130: ELSE
131: INSERT INTO AMW_FIN_PROCESS_FLAT
132: (CERTIFICATION_ID,
133: PARENT_PROCESS_ID,
134: CHILD_PROCESS_ID,
135: ORGANIZATION_ID)
269: SELECT AMW_FIN_CERT_SCOPE_S.NEXTVAL, P_CERTIFICATION_ID, itemaccmerge.statement_group_id, itemaccmerge.financial_statement_id, itemaccmerge.financial_item_id,
270: itemaccmerge.account_group_id, itemaccmerge.natural_account_id,itemaccmerge.organization_id, case when proc.child_process_id = -2 then itemaccmerge.process_id else proc.child_process_id end process_id,
271: 1, sysdate, 1, sysdate, 1, null, 1
272: FROM
273: AMW_FIN_PROCESS_FLAT proc,
274:
275: (SELECT temp.STATEMENT_GROUP_ID, temp.FINANCIAL_STATEMENT_ID, temp.FINANCIAL_ITEM_ID,
276: temp.ACCOUNT_GROUP_ID,
277: case when temp.NATURAL_ACCOUNT_ID = -1 then temp.child_natural_account_id else temp.NATURAL_ACCOUNT_ID end natural_account_id,
344: SELECT AMW_FIN_CERT_SCOPE_S.NEXTVAL, P_CERTIFICATION_ID, itemaccmerge.statement_group_id, itemaccmerge.financial_statement_id, itemaccmerge.financial_item_id,
345: itemaccmerge.account_group_id, itemaccmerge.natural_account_id,itemaccmerge.organization_id, case when proc.child_process_id = -2 then itemaccmerge.process_id else proc.child_process_id end process_id,
346: 1, sysdate, 1, sysdate, 1, null, 1
347: FROM
348: AMW_FIN_PROCESS_FLAT proc,
349:
350: (SELECT temp.STATEMENT_GROUP_ID, temp.FINANCIAL_STATEMENT_ID, temp.FINANCIAL_ITEM_ID,
351: temp.ACCOUNT_GROUP_ID,temp.NATURAL_ACCOUNT_ID,ACCREL.PK1 organization_id, ACCREL.PK2 process_id
352: FROM
412: SELECT AMW_FIN_CERT_SCOPE_S.NEXTVAL, P_CERTIFICATION_ID, itemaccmerge.statement_group_id, itemaccmerge.financial_statement_id, itemaccmerge.financial_item_id,
413: itemaccmerge.account_group_id, itemaccmerge.natural_account_id,itemaccmerge.organization_id, case when proc.child_process_id = -2 then itemaccmerge.process_id else proc.child_process_id end process_id,
414: 1, sysdate, 1, sysdate, 1, null, 1
415: FROM
416: AMW_FIN_PROCESS_FLAT proc,
417:
418: (SELECT temp.STATEMENT_GROUP_ID, temp.FINANCIAL_STATEMENT_ID, temp.FINANCIAL_ITEM_ID,
419: temp.ACCOUNT_GROUP_ID,
420: temp.child_natural_account_id natural_account_id,
490: itemaccmerge.account_group_id, itemaccmerge.natural_account_id,itemaccmerge.organization_id,
491: case when proc.child_process_id = -2 then itemaccmerge.process_id else proc.child_process_id end process_id,
492: 1, sysdate, 1, sysdate, 1, null, 1
493: FROM
494: AMW_FIN_PROCESS_FLAT proc,
495:
496: (SELECT temp.ACCOUNT_GROUP_ID,
497: temp.NATURAL_ACCOUNT_ID,
498: ACCREL.PK1 organization_id, ACCREL.PK2 process_id