[Home] [Help]
98: -- cursor statement to select the info from child table
99: CURSOR c_child IS
100: SELECT wc.LAST_UPDATE_DATE lud, wc.EMPLOYMENT_HISTORY_ID parent_id, eh.party_id party_id,
101: wc.WORK_CLASS_ID child_id
102: FROM HZ_WORK_CLASS wc, HZ_EMPLOYMENT_HISTORY eh, HZ_PARTIES p
103: WHERE wc.WORK_CLASS_ID = P_WORK_CLASS_ID
104: AND wc.employment_history_id = eh.employment_history_id
105: AND eh.party_id = p.party_id
106: AND p.party_type = 'PERSON';
167: p_lud => l_lud,
168: p_centity_name => 'HZ_EMPLOYMENT_HISTORY',
169: p_cbo_code => 'EMP_HIST',
170: p_parent_id => l_party_id,
171: p_pentity_name => 'HZ_PARTIES',
172: p_pbo_code => 'PERSON');
173:
174: -- if record not existing for person of employment history, insert into hz_bus_obj_tracking
175: pop_parent_record(p_child_id => l_party_id,
173:
174: -- if record not existing for person of employment history, insert into hz_bus_obj_tracking
175: pop_parent_record(p_child_id => l_party_id,
176: p_lud => l_lud,
177: p_centity_name => 'HZ_PARTIES',
178: p_cbo_code => 'PERSON',
179: p_parent_id => NULL,
180: p_pentity_name => NULL,
181: p_pbo_code => NULL);
395: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
396: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
397: ) VALUES (
398: 'N', p_operation, l_child_id, 'HZ_RELATIONSHIPS', NULL,
399: l_lud, l_lud, 'HZ_PARTIES', l_subj_id, l_sbo_code);
400:
401: -- for object
402: INSERT INTO HZ_BUS_OBJ_TRACKING
403: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
403: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
404: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
405: ) VALUES (
406: 'N', p_operation, l_child_id, 'HZ_RELATIONSHIPS', NULL,
407: l_lud, l_lud, 'HZ_PARTIES', l_obj_id, l_obo_code);
408:
409: -- if record not existing for customer account contact, insert into hz_bus_obj_tracking
410: pop_parent_record(p_child_id => l_subj_id,
411: p_lud => l_lud,
408:
409: -- if record not existing for customer account contact, insert into hz_bus_obj_tracking
410: pop_parent_record(p_child_id => l_subj_id,
411: p_lud => l_lud,
412: p_centity_name => 'HZ_PARTIES',
413: p_cbo_code => l_sbo_code,
414: p_parent_id => NULL,
415: p_pentity_name => NULL,
416: p_pbo_code => NULL);
416: p_pbo_code => NULL);
417:
418: pop_parent_record(p_child_id => l_obj_id,
419: p_lud => l_lud,
420: p_centity_name => 'HZ_PARTIES',
421: p_cbo_code => l_obo_code,
422: p_parent_id => NULL,
423: p_pentity_name => NULL,
424: p_pbo_code => NULL);
523: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
524: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
525: ) VALUES (
526: 'N', p_operation, l_child_id, 'HZ_PERSON_PROFILES', NULL,
527: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');
528:
529: -- populate person party record
530: pop_parent_record(p_child_id => l_parent_id,
531: p_lud => l_lud,
528:
529: -- populate person party record
530: pop_parent_record(p_child_id => l_parent_id,
531: p_lud => l_lud,
532: p_centity_name => 'HZ_PARTIES',
533: p_cbo_code => 'PERSON',
534: p_parent_id => NULL,
535: p_pentity_name => NULL,
536: p_pbo_code => NULL);
568:
569: -- cursor statement to select the info from child table
570: CURSOR c_child IS
571: SELECT pl.LAST_UPDATE_DATE lud, pl.PARTY_ID parent_id, pl.LANGUAGE_USE_REFERENCE_ID child_id
572: FROM HZ_PERSON_LANGUAGE pl, HZ_PARTIES p
573: WHERE pl.LANGUAGE_USE_REFERENCE_ID = P_LANGUAGE_USE_REFERENCE_ID
574: AND pl.party_id = p.party_id
575: AND p.party_type = 'PERSON';
576:
624: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
625: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
626: ) VALUES (
627: 'N', p_operation, l_child_id, 'HZ_PERSON_LANGUAGE', NULL,
628: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');
629:
630: -- populate party record
631: pop_parent_record(p_child_id => l_parent_id,
632: p_lud => l_lud,
629:
630: -- populate party record
631: pop_parent_record(p_child_id => l_parent_id,
632: p_lud => l_lud,
633: p_centity_name => 'HZ_PARTIES',
634: p_cbo_code => 'PERSON',
635: p_parent_id => NULL,
636: p_pentity_name => NULL,
637: p_pbo_code => NULL);
669:
670: -- cursor statement to select the info from child table
671: CURSOR C_child IS
672: SELECT pi.LAST_UPDATE_DATE lud, pi.PARTY_ID parent_id, pi.PERSON_INTEREST_ID child_id
673: FROM HZ_PERSON_INTEREST pi, HZ_PARTIES p
674: WHERE pi.PERSON_INTEREST_ID = P_PERSON_INTEREST_ID
675: AND pi.party_id = p.party_id
676: AND p.party_type = 'PERSON';
677:
725: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
726: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
727: ) VALUES (
728: 'N', p_operation, l_child_id, 'HZ_PERSON_INTEREST', NULL,
729: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');
730:
731: -- populate party record
732: pop_parent_record(p_child_id => l_parent_id,
733: p_lud => l_lud,
730:
731: -- populate party record
732: pop_parent_record(p_child_id => l_parent_id,
733: p_lud => l_lud,
734: p_centity_name => 'HZ_PARTIES',
735: p_cbo_code => 'PERSON',
736: p_parent_id => NULL,
737: p_pentity_name => NULL,
738: p_pbo_code => NULL);
771: -- cursor statement to select the info from child table
772: CURSOR C_child IS
773: SELECT psu.LAST_UPDATE_DATE lud, psu.PARTY_SITE_ID parent_id, psu.PARTY_SITE_USE_ID child_id,
774: p.party_type, p.party_id
775: FROM HZ_PARTY_SITE_USES psu, HZ_PARTY_SITES ps, HZ_PARTIES p
776: WHERE psu.PARTY_SITE_USE_ID = P_PARTY_SITE_USE_ID
777: AND psu.party_site_id = ps.party_site_id
778: AND ps.party_id = p.party_id
779: AND p.party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');
890:
891: -- cursor statement to select the info from child table
892: CURSOR c_child IS
893: SELECT ps.LAST_UPDATE_DATE lud, ps.PARTY_ID parent_id,
894: decode(p.party_type, 'PARTY_RELATIONSHIP', 'HZ_ORG_CONTACTS', 'HZ_PARTIES') parent_tbl_name,
895: ps.PARTY_SITE_ID child_id,
896: decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', 'PARTY_RELATIONSHIP', 'ORG_CONTACT', null) bo_code,
897: ps.location_id location_id
898: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
894: decode(p.party_type, 'PARTY_RELATIONSHIP', 'HZ_ORG_CONTACTS', 'HZ_PARTIES') parent_tbl_name,
895: ps.PARTY_SITE_ID child_id,
896: decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', 'PARTY_RELATIONSHIP', 'ORG_CONTACT', null) bo_code,
897: ps.location_id location_id
898: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
899: WHERE ps.PARTY_SITE_ID = P_PARTY_SITE_ID
900: AND ps.party_id = p.party_id
901: AND p.party_type in ('ORGANIZATION','PERSON','PARTY_RELATIONSHIP');
902:
1015: PROCEDURE pop_hz_party_preferences(p_operation IN VARCHAR2, p_party_preference_id IN NUMBER) IS
1016:
1017: CURSOR C_child IS
1018: SELECT pp.LAST_UPDATE_DATE lud, pp.PARTY_ID parent_id,
1019: 'HZ_PARTIES' parent_tbl_name, pp.PARTY_PREFERENCE_ID child_id,
1020: decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) bo_code
1021: FROM HZ_PARTY_PREFERENCES pp, HZ_PARTIES p
1022: WHERE pp.PARTY_PREFERENCE_ID = p_party_preference_id
1023: AND pp.party_id = p.party_id
1017: CURSOR C_child IS
1018: SELECT pp.LAST_UPDATE_DATE lud, pp.PARTY_ID parent_id,
1019: 'HZ_PARTIES' parent_tbl_name, pp.PARTY_PREFERENCE_ID child_id,
1020: decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) bo_code
1021: FROM HZ_PARTY_PREFERENCES pp, HZ_PARTIES p
1022: WHERE pp.PARTY_PREFERENCE_ID = p_party_preference_id
1023: AND pp.party_id = p.party_id
1024: AND p.party_type in ('ORGANIZATION', 'PERSON');
1025:
1083:
1084: -- populate party record
1085: pop_parent_record(p_child_id => l_parent_id,
1086: p_lud => l_lud,
1087: p_centity_name => 'HZ_PARTIES',
1088: p_cbo_code => l_bo_code,
1089: p_parent_id => NULL,
1090: p_pentity_name => NULL,
1091: p_pbo_code => NULL);
1193: p_lud => l_lud,
1194: p_centity_name => 'HZ_ORG_CONTACTS',
1195: p_cbo_code => 'ORG_CONTACT',
1196: p_parent_id => l_org_id,
1197: p_pentity_name => 'HZ_PARTIES',
1198: p_pbo_code => 'ORG');
1199: END ; -- anonymous block end
1200: END LOOP;
1201:
1302: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
1303: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
1304: ) VALUES (
1305: 'N', p_operation, l_child_id, 'HZ_ORG_CONTACTS', 'ORG_CONTACT',
1306: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'ORG');
1307:
1308: -- populate subject person as child
1309: pop_parent_record(p_child_id => l_person_id,
1310: p_lud => l_lud,
1307:
1308: -- populate subject person as child
1309: pop_parent_record(p_child_id => l_person_id,
1310: p_lud => l_lud,
1311: p_centity_name => 'HZ_PARTIES',
1312: p_cbo_code => 'PERSON_CONTACT',
1313: p_parent_id => l_child_id,
1314: p_pentity_name => 'HZ_ORG_CONTACTS',
1315: p_pbo_code => 'ORG_CONTACT');
1410: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
1411: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
1412: ) VALUES (
1413: 'N', p_operation, l_child_id, 'HZ_ORGANIZATION_PROFILES', NULL,
1414: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'ORG');
1415:
1416: -- populate org party record
1417: pop_parent_record(p_child_id => l_parent_id,
1418: p_lud => l_lud,
1415:
1416: -- populate org party record
1417: pop_parent_record(p_child_id => l_parent_id,
1418: p_lud => l_lud,
1419: p_centity_name => 'HZ_PARTIES',
1420: p_cbo_code => 'ORG',
1421: p_parent_id => NULL,
1422: p_pentity_name => NULL,
1423: p_pbo_code => NULL);
1459: WHERE location_id = p_location_id;
1460:
1461: CURSOR c_ps(l_loc_id NUMBER) IS
1462: SELECT party_site_id
1463: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
1464: WHERE ps.location_id = l_loc_id
1465: AND ps.party_id = p.party_id;
1466:
1467: -- local variables
1559: -- cursor statement to select the info from child table
1560: CURSOR C_child IS
1561: SELECT fr.LAST_UPDATE_DATE lud, fr.PARTY_ID parent_id, fr.FINANCIAL_REPORT_ID child_id,
1562: decode(p.party_type, 'ORGANIZATION', 'ORG', null) bo_code
1563: FROM HZ_FINANCIAL_REPORTS fr, HZ_PARTIES p
1564: WHERE fr.FINANCIAL_REPORT_ID = P_FINANCIAL_REPORT_ID
1565: AND fr.party_id = p.party_id
1566: AND p.party_type = 'ORGANIZATION';
1567:
1627: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
1628: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
1629: ) VALUES (
1630: 'N', p_operation, l_child_id, 'HZ_FINANCIAL_REPORTS', 'FIN_REPORT',
1631: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);
1632:
1633: -- populate org party record
1634: pop_parent_record(p_child_id => l_parent_id,
1635: p_lud => l_lud,
1632:
1633: -- populate org party record
1634: pop_parent_record(p_child_id => l_parent_id,
1635: p_lud => l_lud,
1636: p_centity_name => 'HZ_PARTIES',
1637: p_cbo_code => l_bo_code,
1638: p_parent_id => NULL,
1639: p_pentity_name => NULL,
1640: p_pbo_code => NULL);
1675: CURSOR c_child IS
1676: SELECT fp.LAST_UPDATE_DATE lud, fp.PARTY_ID parent_id,
1677: fp.FINANCIAL_PROFILE_ID child_id,
1678: decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) bo_code
1679: FROM HZ_FINANCIAL_PROFILE fp, HZ_PARTIES p
1680: WHERE fp.FINANCIAL_PROFILE_ID = P_FINANCIAL_PROFILE_ID
1681: AND fp.party_id = p.party_id
1682: AND p.party_type in ('ORGANIZATION', 'PERSON');
1683:
1733: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
1734: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
1735: ) VALUES (
1736: 'N', p_operation, l_child_id, 'HZ_FINANCIAL_PROFILE', NULL,
1737: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);
1738:
1739: -- populate org party record
1740: pop_parent_record(p_child_id => l_parent_id,
1741: p_lud => l_lud,
1738:
1739: -- populate org party record
1740: pop_parent_record(p_child_id => l_parent_id,
1741: p_lud => l_lud,
1742: p_centity_name => 'HZ_PARTIES',
1743: p_cbo_code => l_bo_code,
1744: p_parent_id => NULL,
1745: p_pentity_name => NULL,
1746: p_pbo_code => NULL);
1779: -- cursor statement to select the info from child table
1780: CURSOR C_child IS
1781: SELECT fn.LAST_UPDATE_DATE lud, fn.FINANCIAL_REPORT_ID parent_id,
1782: fn.FINANCIAL_NUMBER_ID child_id, fr.party_id party_id
1783: FROM HZ_FINANCIAL_NUMBERS fn, HZ_FINANCIAL_REPORTS fr, HZ_PARTIES p
1784: WHERE fn.FINANCIAL_NUMBER_ID = P_FINANCIAL_NUMBER_ID
1785: AND fn.financial_report_id = fr.financial_report_id
1786: AND fr.party_id = p.party_id
1787: AND p.party_type = 'ORGANIZATION';
1846: p_lud => l_lud,
1847: p_centity_name => 'HZ_FINANCIAL_REPORTS',
1848: p_cbo_code => 'FIN_REPORT',
1849: p_parent_id => l_party_id,
1850: p_pentity_name => 'HZ_PARTIES',
1851: p_pbo_code => 'ORG');
1852:
1853: -- populate org party record
1854: pop_parent_record(p_child_id => l_party_id,
1852:
1853: -- populate org party record
1854: pop_parent_record(p_child_id => l_party_id,
1855: p_lud => l_lud,
1856: p_centity_name => 'HZ_PARTIES',
1857: p_cbo_code => 'ORG',
1858: p_parent_id => NULL,
1859: p_pentity_name => NULL,
1860: p_pbo_code => NULL);
1893: -- cursor statement to select the info from child table
1894: CURSOR C_child IS
1895: SELECT eh.LAST_UPDATE_DATE lud, eh.PARTY_ID parent_id,
1896: eh.EMPLOYMENT_HISTORY_ID child_id
1897: FROM HZ_EMPLOYMENT_HISTORY eh, HZ_PARTIES p
1898: WHERE eh.EMPLOYMENT_HISTORY_ID = P_EMPLOYMENT_HISTORY_ID
1899: AND eh.party_id = p.party_id
1900: AND p.party_type = 'PERSON';
1901:
1958: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
1959: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
1960: ) VALUES (
1961: 'N', p_operation, l_child_id, 'HZ_EMPLOYMENT_HISTORY', 'EMP_HIST',
1962: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');
1963:
1964: -- populate org party record
1965: pop_parent_record(p_child_id => l_parent_id,
1966: p_lud => l_lud,
1963:
1964: -- populate org party record
1965: pop_parent_record(p_child_id => l_parent_id,
1966: p_lud => l_lud,
1967: p_centity_name => 'HZ_PARTIES',
1968: p_cbo_code => 'PERSON',
1969: p_parent_id => NULL,
1970: p_pentity_name => NULL,
1971: p_pbo_code => NULL);
2003:
2004: -- cursor statement to select the info from child table
2005: CURSOR C_child IS
2006: SELECT edu.LAST_UPDATE_DATE lud, edu.PARTY_ID parent_id, edu.EDUCATION_ID child_id
2007: FROM HZ_EDUCATION edu, HZ_PARTIES p
2008: WHERE edu.EDUCATION_ID = P_EDUCATION_ID
2009: AND edu.party_id = p.party_id
2010: AND p.party_type = 'PERSON';
2011:
2059: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
2060: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
2061: ) VALUES (
2062: 'N', p_operation, l_child_id, 'HZ_EDUCATION', NULL,
2063: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');
2064:
2065: -- populate org party record
2066: pop_parent_record(p_child_id => l_parent_id,
2067: p_lud => l_lud,
2064:
2065: -- populate org party record
2066: pop_parent_record(p_child_id => l_parent_id,
2067: p_lud => l_lud,
2068: p_centity_name => 'HZ_PARTIES',
2069: p_cbo_code => 'PERSON',
2070: p_parent_id => NULL,
2071: p_pentity_name => NULL,
2072: p_pbo_code => NULL);
2313: CURSOR C_child IS
2314: SELECT cas.LAST_UPDATE_DATE lud, cas.CUST_ACCOUNT_ID parent_id, cas.CUST_ACCT_SITE_ID child_id,
2315: ca.party_id ca_parent_id,
2316: decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) ca_parent_bo
2317: FROM HZ_CUST_ACCT_SITES_ALL cas, HZ_CUST_ACCOUNTS ca, HZ_PARTIES p
2318: WHERE cas.CUST_ACCT_SITE_ID = P_CUST_ACCT_SITE_ID
2319: AND cas.cust_account_id = ca.cust_account_id
2320: AND ca.party_id = p.party_id
2321: AND p.party_type in ('ORGANIZATION', 'PERSON')
2429: decode(p.party_type, 'ORGANIZATION', 'ORG_CUST', 'PERSON', 'PERSON_CUST', NULL) pbo,
2430: decode(rel_p.party_type, 'ORGANIZATION', 'ORG_CUST', 'PERSON', 'PERSON_CUST', NULL) rel_pbo,
2431: p.party_id pid, rel_p.party_id rel_pid
2432: FROM HZ_CUST_ACCT_RELATE_ALL car, HZ_CUST_ACCOUNTS ca, HZ_CUST_ACCOUNTS rel_ca,
2433: HZ_PARTIES p, HZ_PARTIES rel_p
2434: WHERE car.cust_acct_relate_id = p_cust_acct_relate_id
2435: AND car.cust_account_id = ca.cust_account_id
2436: AND car.related_cust_account_id = rel_ca.cust_account_id
2437: AND ca.party_id = p.party_id
2506: p_lud => l_lud,
2507: p_centity_name => 'HZ_CUST_ACCOUNTS',
2508: p_cbo_code => 'CUST_ACCT',
2509: p_parent_id => l_pid,
2510: p_pentity_name => 'HZ_PARTIES',
2511: p_pbo_code => l_pbo);
2512:
2513: pop_parent_record(p_child_id => l_pid,
2514: p_lud => l_lud,
2511: p_pbo_code => l_pbo);
2512:
2513: pop_parent_record(p_child_id => l_pid,
2514: p_lud => l_lud,
2515: p_centity_name => 'HZ_PARTIES',
2516: p_cbo_code => l_pbo,
2517: p_parent_id => NULL,
2518: p_pentity_name => NULL,
2519: p_pbo_code => NULL);
2529: p_lud => l_lud,
2530: p_centity_name => 'HZ_CUST_ACCOUNTS',
2531: p_cbo_code => 'CUST_ACCT',
2532: p_parent_id => l_rel_pid,
2533: p_pentity_name => 'HZ_PARTIES',
2534: p_pbo_code => l_rel_pbo);
2535:
2536: pop_parent_record(p_child_id => l_rel_pid,
2537: p_lud => l_lud,
2534: p_pbo_code => l_rel_pbo);
2535:
2536: pop_parent_record(p_child_id => l_rel_pid,
2537: p_lud => l_lud,
2538: p_centity_name => 'HZ_PARTIES',
2539: p_cbo_code => l_rel_pbo,
2540: p_parent_id => NULL,
2541: p_pentity_name => NULL,
2542: p_pbo_code => NULL);
2580: nvl(car.cust_acct_site_id, car.cust_account_id) parent_id,
2581: decode(car.cust_acct_site_id, null, 'CUST_ACCT', 'CUST_ACCT_SITE') parent_bo,
2582: decode(car.cust_acct_site_id, null, 'HZ_CUST_ACCOUNTS', 'HZ_CUST_ACCT_SITES_ALL') parent_entity,
2583: ca.cust_account_id ca_id
2584: FROM HZ_CUST_ACCOUNT_ROLES car, HZ_CUST_ACCOUNTS ca, HZ_PARTIES p
2585: WHERE car.CUST_ACCOUNT_ROLE_ID = P_CUST_ACCOUNT_ROLE_ID
2586: AND car.cust_account_id = ca.cust_account_id
2587: AND ca.party_id = p.party_id
2588: AND p.party_type in ('ORGANIZATION', 'PERSON')
2689: -- cursor statement to select the info from child table
2690: CURSOR C_child IS
2691: SELECT ca.LAST_UPDATE_DATE lud, ca.PARTY_ID parent_id, ca.CUST_ACCOUNT_ID child_id,
2692: decode(p.party_type, 'ORGANIZATION', 'ORG_CUST', 'PERSON', 'PERSON_CUST', NULL) bo_code
2693: FROM HZ_CUST_ACCOUNTS ca, HZ_PARTIES p
2694: WHERE ca.CUST_ACCOUNT_ID = P_CUST_ACCOUNT_ID
2695: AND ca.party_id = p.party_id
2696: AND p.party_type in ('ORGANIZATION', 'PERSON')
2697: AND ca.cust_account_id > 0;
2757: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
2758: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
2759: ) VALUES (
2760: 'N', p_operation, l_child_id, 'HZ_CUST_ACCOUNTS', 'CUST_ACCT',
2761: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);
2762: END ; -- anonymous block end
2763: END LOOP;
2764:
2765: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_cust_accounts-',
2906:
2907: -- cursor statement to select the info from child table
2908: CURSOR C_child IS
2909: SELECT cr.LAST_UPDATE_DATE lud, cr.PARTY_ID parent_id, cr.CREDIT_RATING_ID child_id
2910: FROM HZ_CREDIT_RATINGS cr, HZ_PARTIES p
2911: WHERE cr.CREDIT_RATING_ID = P_CREDIT_RATING_ID
2912: AND cr.party_id = p.party_id
2913: AND p.party_type = 'ORGANIZATION';
2914:
2962: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
2963: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
2964: ) VALUES (
2965: 'N', p_operation, l_child_id, 'HZ_CREDIT_RATINGS', NULL,
2966: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'ORG');
2967:
2968: pop_parent_record(p_child_id => l_parent_id,
2969: p_lud => l_lud,
2970: p_centity_name => 'HZ_PARTIES',
2966: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'ORG');
2967:
2968: pop_parent_record(p_child_id => l_parent_id,
2969: p_lud => l_lud,
2970: p_centity_name => 'HZ_PARTIES',
2971: p_cbo_code => 'ORG',
2972: p_parent_id => NULL,
2973: p_pentity_name => NULL,
2974: p_pbo_code => NULL);
3027: AND contact_point_type in ('PHONE', 'EMAIL', 'TLX', 'WEB', 'EFT', 'EDI', 'SMS');
3028:
3029: CURSOR c_pty(p_parent_id NUMBER) IS
3030: SELECT decode(party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', 'PARTY_RELATIONSHIP', 'ORG_CONTACT', NULL),
3031: decode(party_type, 'ORGANIZATION', 'HZ_PARTIES', 'PERSON', 'HZ_PARTIES', 'PARTY_RELATIONSHIP', 'HZ_ORG_CONTACTS', NULL)
3032: FROM HZ_PARTIES
3033: WHERE party_id = p_parent_id
3034: AND party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');
3035:
3028:
3029: CURSOR c_pty(p_parent_id NUMBER) IS
3030: SELECT decode(party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', 'PARTY_RELATIONSHIP', 'ORG_CONTACT', NULL),
3031: decode(party_type, 'ORGANIZATION', 'HZ_PARTIES', 'PERSON', 'HZ_PARTIES', 'PARTY_RELATIONSHIP', 'HZ_ORG_CONTACTS', NULL)
3032: FROM HZ_PARTIES
3033: WHERE party_id = p_parent_id
3034: AND party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');
3035:
3036: CURSOR c_oc(p_parent_id NUMBER) IS
3087: ELSIF(l_parent_tbl_name = 'HZ_CONTACT_POINTS') THEN
3088: OPEN c_cp(l_parent_id);
3089: FETCH c_cp INTO l_bo_code, l_cp_owner_table, l_cp_owner_id;
3090: CLOSE c_cp;
3091: IF l_bo_code in ('PHONE', 'SMS', 'EDI') and l_cp_owner_table = 'HZ_PARTIES' THEN
3092: OPEN c_pty(l_cp_owner_id);
3093: FETCH c_pty INTO l_pty_bo_code, l_pty_tbl_name;
3094: CLOSE c_pty;
3095: IF(l_bo_code = 'PHONE' AND l_pty_bo_code IS NULL) THEN
3106: ELSIF(l_bo_code = 'EDI' AND l_pty_bo_code = 'PERSON') THEN
3107: RETURN;
3108: END IF;
3109: END IF;
3110: ELSIF(l_parent_tbl_name = 'HZ_PARTIES') THEN
3111: OPEN c_pty(l_parent_id);
3112: FETCH c_pty INTO l_bo_code, l_parent_tbl_name;
3113: CLOSE c_pty;
3114: IF(l_bo_code = 'ORG_CONTACT') THEN
3202: SELECT LAST_UPDATE_DATE lud, OWNER_TABLE_ID parent_id, CONTACT_POINT_ID child_id,
3203: OWNER_TABLE_NAME parent_entity, CONTACT_POINT_TYPE child_bo_code
3204: FROM HZ_CONTACT_POINTS
3205: WHERE CONTACT_POINT_ID = P_CONTACT_POINT_ID
3206: AND OWNER_TABLE_NAME in ('HZ_PARTY_SITES', 'HZ_PARTIES');
3207:
3208: -- cursor statement to select the info from party parent table
3209: CURSOR c_party_parent(p_parent_id IN NUMBER) IS
3210: SELECT decode(party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', 'PARTY_RELATIONSHIP', 'ORG_CONTACT', NULL),
3207:
3208: -- cursor statement to select the info from party parent table
3209: CURSOR c_party_parent(p_parent_id IN NUMBER) IS
3210: SELECT decode(party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', 'PARTY_RELATIONSHIP', 'ORG_CONTACT', NULL),
3211: decode(party_type, 'ORGANIZATION', 'HZ_PARTIES', 'PERSON', 'HZ_PARTIES', 'PARTY_RELATIONSHIP', 'HZ_ORG_CONTACTS', NULL)
3212: FROM HZ_PARTIES
3213: WHERE PARTY_ID = p_parent_id
3214: AND party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');
3215:
3208: -- cursor statement to select the info from party parent table
3209: CURSOR c_party_parent(p_parent_id IN NUMBER) IS
3210: SELECT decode(party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', 'PARTY_RELATIONSHIP', 'ORG_CONTACT', NULL),
3211: decode(party_type, 'ORGANIZATION', 'HZ_PARTIES', 'PERSON', 'HZ_PARTIES', 'PARTY_RELATIONSHIP', 'HZ_ORG_CONTACTS', NULL)
3212: FROM HZ_PARTIES
3213: WHERE PARTY_ID = p_parent_id
3214: AND party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');
3215:
3216: CURSOR c_oc(p_parent_id NUMBER) IS
3257: l_parent_tbl_name := c_child_rec.parent_entity;
3258:
3259: IF(l_parent_tbl_name = 'HZ_PARTY_SITES') THEN
3260: l_bo_code := 'PARTY_SITE';
3261: ELSIF(l_parent_tbl_name = 'HZ_PARTIES') THEN
3262: OPEN c_party_parent(l_parent_id);
3263: FETCH c_party_parent INTO l_bo_code, l_parent_tbl_name;
3264: CLOSE c_party_parent;
3265: IF(l_bo_code = 'ORG_CONTACT') THEN
3357:
3358: CURSOR C_child IS
3359: SELECT pp.LAST_UPDATE_DATE lud, pp.OWNER_TABLE_ID parent_id, pp.CODE_ASSIGNMENT_ID child_id,
3360: decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) bo_code
3361: FROM HZ_CODE_ASSIGNMENTS pp, HZ_PARTIES p
3362: WHERE pp.code_assignment_id = p_code_assignment_id
3363: AND pp.OWNER_TABLE_ID = p.party_id
3364: AND pp.OWNER_TABLE_NAME = 'HZ_PARTIES'
3365: AND p.party_type in ('ORGANIZATION', 'PERSON');
3360: decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) bo_code
3361: FROM HZ_CODE_ASSIGNMENTS pp, HZ_PARTIES p
3362: WHERE pp.code_assignment_id = p_code_assignment_id
3363: AND pp.OWNER_TABLE_ID = p.party_id
3364: AND pp.OWNER_TABLE_NAME = 'HZ_PARTIES'
3365: AND p.party_type in ('ORGANIZATION', 'PERSON');
3366:
3367: -- local variables
3368: l_debug_prefix VARCHAR2(40) := 'pop_hz_code_assignments';
3416: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
3417: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
3418: ) VALUES (
3419: 'N', p_operation, l_child_id, 'HZ_CODE_ASSIGNMENTS', NULL,
3420: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);
3421:
3422: pop_parent_record(p_child_id => l_parent_id,
3423: p_lud => l_lud,
3424: p_centity_name => 'HZ_PARTIES',
3420: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);
3421:
3422: pop_parent_record(p_child_id => l_parent_id,
3423: p_lud => l_lud,
3424: p_centity_name => 'HZ_PARTIES',
3425: p_cbo_code => l_bo_code,
3426: p_parent_id => NULL,
3427: p_pentity_name => NULL,
3428: p_pbo_code => NULL);
3460:
3461: -- cursor statement to select the info from child table
3462: CURSOR C_child IS
3463: SELECT c.LAST_UPDATE_DATE lud, c.PARTY_ID parent_id, c.CITIZENSHIP_ID child_id
3464: FROM HZ_CITIZENSHIP c, HZ_PARTIES p
3465: WHERE c.CITIZENSHIP_ID = P_CITIZENSHIP_ID
3466: AND c.party_id = p.party_id
3467: AND p.party_type = 'PERSON';
3468:
3516: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
3517: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
3518: ) VALUES (
3519: 'N', p_operation, l_child_id, 'HZ_CITIZENSHIP', NULL,
3520: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');
3521:
3522: pop_parent_record(p_child_id => l_parent_id,
3523: p_lud => l_lud,
3524: p_centity_name => 'HZ_PARTIES',
3520: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');
3521:
3522: pop_parent_record(p_child_id => l_parent_id,
3523: p_lud => l_lud,
3524: p_centity_name => 'HZ_PARTIES',
3525: p_cbo_code => 'PERSON',
3526: p_parent_id => NULL,
3527: p_pentity_name => NULL,
3528: p_pbo_code => NULL);
3562: -- cursor statement to select the info from child table
3563: CURSOR C_child IS
3564: SELECT c.LAST_UPDATE_DATE lud, c.PARTY_ID parent_id, c.CERTIFICATION_ID child_id,
3565: decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) bo_code
3566: FROM HZ_CERTIFICATIONS c, HZ_PARTIES p
3567: WHERE c.CERTIFICATION_ID = P_CERTIFICATION_ID
3568: AND c.party_id = p.party_id
3569: AND p.party_type in ('ORGANIZATION', 'PERSON');
3570:
3619: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
3620: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
3621: ) VALUES (
3622: 'N', p_operation, l_child_id, 'HZ_CERTIFICATIONS', NULL,
3623: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);
3624:
3625: pop_parent_record(p_child_id => l_parent_id,
3626: p_lud => l_lud,
3627: p_centity_name => 'HZ_PARTIES',
3623: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);
3624:
3625: pop_parent_record(p_child_id => l_parent_id,
3626: p_lud => l_lud,
3627: p_centity_name => 'HZ_PARTIES',
3628: p_cbo_code => l_bo_code,
3629: p_parent_id => NULL,
3630: p_pentity_name => NULL,
3631: p_pbo_code => NULL);
3666: -- cursor statement to select the info from child table
3667: CURSOR C_child IS
3668: SELECT c.LAST_UPDATE_DATE lud, c.PARTY_ID parent_id, c.PARTY_USG_ASSIGNMENT_ID child_id,
3669: decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) bo_code
3670: FROM HZ_PARTY_USG_ASSIGNMENTS c, HZ_PARTIES p
3671: WHERE c.PARTY_USG_ASSIGNMENT_ID = P_PARTY_USG_ASSIGNMENT_ID
3672: AND c.party_id = p.party_id
3673: AND p.party_type in ('ORGANIZATION', 'PERSON');
3674:
3723: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
3724: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
3725: ) VALUES (
3726: 'N', p_operation, l_child_id, 'HZ_PARTY_USG_ASSIGNMENTS', NULL,
3727: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);
3728:
3729: pop_parent_record(p_child_id => l_parent_id,
3730: p_lud => l_lud,
3731: p_centity_name => 'HZ_PARTIES',
3727: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);
3728:
3729: pop_parent_record(p_child_id => l_parent_id,
3730: p_lud => l_lud,
3731: p_centity_name => 'HZ_PARTIES',
3732: p_cbo_code => l_bo_code,
3733: p_parent_id => NULL,
3734: p_pentity_name => NULL,
3735: p_pbo_code => NULL);
3769: PROCEDURE pop_hz_extensibility(p_operation IN VARCHAR2, p_object_type IN VARCHAR2, p_extension_id IN NUMBER) IS
3770:
3771: -- cursor statement to select the info from child table
3772: CURSOR C_child_org IS
3773: SELECT c.LAST_UPDATE_DATE lud, p.PARTY_ID parent_id, c.extension_id child_id, 'ORG' bo_code, 'HZ_PARTIES' parent_entity
3774: FROM HZ_ORG_PROFILES_EXT_B c, HZ_ORGANIZATION_PROFILES p
3775: WHERE c.EXTENSION_ID = P_EXTENSION_ID
3776: AND c.ORGANIZATION_PROFILE_ID = p.ORGANIZATION_PROFILE_ID
3777: AND rownum = 1;
3776: AND c.ORGANIZATION_PROFILE_ID = p.ORGANIZATION_PROFILE_ID
3777: AND rownum = 1;
3778:
3779: CURSOR C_child_per IS
3780: SELECT c.LAST_UPDATE_DATE lud, p.PARTY_ID parent_id, c.extension_id child_id, 'PERSON' bo_code, 'HZ_PARTIES' parent_entity
3781: FROM HZ_PER_PROFILES_EXT_B c, HZ_PERSON_PROFILES p
3782: WHERE c.EXTENSION_ID = P_EXTENSION_ID
3783: AND c.PERSON_PROFILE_ID = p.PERSON_PROFILE_ID
3784: AND rownum = 1;
3915: nvl(rcrm.site_use_id, rcrm.customer_id) parent_id,
3916: decode(rcrm.site_use_id, NULL, 'HZ_CUST_ACCOUNTS', 'HZ_CUST_SITE_USES_ALL') parent_tbl_name,
3917: decode(rcrm.site_use_id, NULL, 'CUST_ACCT', 'CUST_ACCT_SITE_USE') parent_bo_code,
3918: decode(rcrm.site_use_id, NULL, p.party_id, rcrm.customer_id) grand_parent_id,
3919: decode(rcrm.site_use_id, NULL, 'HZ_PARTIES', 'HZ_CUST_ACCOUNTS') grand_parent_tbl_name,
3920: decode(rcrm.site_use_id, NULL, decode(p.party_type, 'ORGANIZATION', 'ORG_CUST', 'PERSON', 'PERSON_CUST', NULL), 'CUST_ACCT') grand_parent_bo_code
3921: FROM RA_CUST_RECEIPT_METHODS rcrm, HZ_CUST_ACCOUNTS ca, HZ_PARTIES p
3922: WHERE rcrm.cust_receipt_method_id = p_cust_receipt_method_id
3923: AND rcrm.customer_id = ca.cust_account_id
3917: decode(rcrm.site_use_id, NULL, 'CUST_ACCT', 'CUST_ACCT_SITE_USE') parent_bo_code,
3918: decode(rcrm.site_use_id, NULL, p.party_id, rcrm.customer_id) grand_parent_id,
3919: decode(rcrm.site_use_id, NULL, 'HZ_PARTIES', 'HZ_CUST_ACCOUNTS') grand_parent_tbl_name,
3920: decode(rcrm.site_use_id, NULL, decode(p.party_type, 'ORGANIZATION', 'ORG_CUST', 'PERSON', 'PERSON_CUST', NULL), 'CUST_ACCT') grand_parent_bo_code
3921: FROM RA_CUST_RECEIPT_METHODS rcrm, HZ_CUST_ACCOUNTS ca, HZ_PARTIES p
3922: WHERE rcrm.cust_receipt_method_id = p_cust_receipt_method_id
3923: AND rcrm.customer_id = ca.cust_account_id
3924: AND ca.party_id = p.party_id
3925: AND p.party_type in ('ORGANIZATION', 'PERSON')
4013: p_party_site_id IN NUMBER
4014: ) RETURN BOOLEAN IS
4015: CURSOR get_ps IS
4016: SELECT p.party_type, p.party_id
4017: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
4018: WHERE ps.party_site_id = p_party_site_id
4019: AND ps.party_id = p.party_id
4020: AND p.party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');
4021:
4020: AND p.party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');
4021:
4022: CURSOR get_oc(l_party_id NUMBER) IS
4023: SELECT 1
4024: FROM HZ_PARTIES p, HZ_RELATIONSHIPS r
4025: WHERE p.party_id = l_party_id
4026: AND p.party_id = r.party_id
4027: AND r.subject_type = 'PERSON'
4028: AND r.object_type = 'ORGANIZATION'