[Home] [Help]
44:
45: BEGIN
46: l_child_rec_exists_no := 0;
47: SELECT child_id INTO l_child_rec_exists_no
48: FROM HZ_BUS_OBJ_TRACKING
49: WHERE event_id IS NULL
50: AND CHILD_ENTITY_NAME = p_centity_name
51: AND CHILD_BO_CODE = p_cbo_code
52: AND CHILD_ID = p_child_id
61: p_msg_level=>fnd_log.level_procedure);
62: END IF;
63: EXCEPTION
64: WHEN NO_DATA_FOUND THEN
65: INSERT INTO HZ_BUS_OBJ_TRACKING
66: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
67: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
68: ) VALUES (
69: 'Y', 'U', p_child_id, p_centity_name, p_cbo_code,
136: l_parent_id := c_child_rec.parent_id;
137: l_child_id := c_child_rec.child_id;
138: l_party_id := c_child_rec.party_id;
139:
140: -- if record not existing for work class, insert into hz_bus_obj_tracking
141: BEGIN
142: l_child_rec_exists_no := 0;
143: SELECT child_id INTO l_child_rec_exists_no
144: FROM HZ_BUS_OBJ_TRACKING
140: -- if record not existing for work class, insert into hz_bus_obj_tracking
141: BEGIN
142: l_child_rec_exists_no := 0;
143: SELECT child_id INTO l_child_rec_exists_no
144: FROM HZ_BUS_OBJ_TRACKING
145: WHERE event_id IS NULL
146: AND CHILD_ENTITY_NAME = l_cen
147: AND CHILD_ID = l_child_id
148: AND rownum = 1;
154: p_msg_level=>fnd_log.level_procedure);
155: END IF;
156: EXCEPTION
157: WHEN NO_DATA_FOUND THEN
158: INSERT INTO HZ_BUS_OBJ_TRACKING
159: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
160: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
161: ) VALUES (
162: 'N', p_operation, l_child_id, 'HZ_WORK_CLASS', NULL,
161: ) VALUES (
162: 'N', p_operation, l_child_id, 'HZ_WORK_CLASS', NULL,
163: l_lud, l_lud, 'HZ_EMPLOYMENT_HISTORY', l_parent_id, 'EMP_HIST');
164:
165: -- if record not existing for employment history, insert into hz_bus_obj_tracking
166: pop_parent_record(p_child_id => l_parent_id,
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,
176: p_lud => l_lud,
177: p_centity_name => 'HZ_PARTIES',
178: p_cbo_code => 'PERSON',
255: l_car_parent_id := c_child_rec.car_parent_id;
256: l_car_parent_entity := c_child_rec.car_parent_entity;
257: l_car_parent_bo := c_child_rec.car_parent_bo;
258:
259: -- if record not existing, insert into hz_bus_obj_tracking
260: BEGIN
261: l_child_rec_exists_no := 0;
262: SELECT child_id INTO l_child_rec_exists_no
263: FROM HZ_BUS_OBJ_TRACKING
259: -- if record not existing, insert into hz_bus_obj_tracking
260: BEGIN
261: l_child_rec_exists_no := 0;
262: SELECT child_id INTO l_child_rec_exists_no
263: FROM HZ_BUS_OBJ_TRACKING
264: WHERE event_id IS NULL
265: AND CHILD_ENTITY_NAME = l_cen
266: AND CHILD_ID = l_child_id
267: AND rownum = 1;
273: p_msg_level=>fnd_log.level_procedure);
274: END IF;
275: EXCEPTION
276: WHEN NO_DATA_FOUND THEN
277: INSERT INTO HZ_BUS_OBJ_TRACKING
278: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
279: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
280: ) VALUES (
281: 'N', p_operation, l_child_id, 'HZ_ROLE_RESPONSIBILITY', NULL,
280: ) VALUES (
281: 'N', p_operation, l_child_id, 'HZ_ROLE_RESPONSIBILITY', NULL,
282: l_lud, l_lud, 'HZ_CUST_ACCOUNT_ROLES', l_parent_id, 'CUST_ACCT_CONTACT');
283:
284: -- if record not existing for customer account contact, insert into hz_bus_obj_tracking
285: pop_parent_record(p_child_id => l_parent_id,
286: p_lud => l_lud,
287: p_centity_name => 'HZ_CUST_ACCOUNT_ROLES',
288: p_cbo_code => 'CUST_ACCT_CONTACT',
371: l_sbo_code := c_child_rec.sbo_code;
372: l_obo_code := c_child_rec.obo_code;
373: l_child_id := c_child_rec.child_id;
374:
375: -- if record not existing, insert into hz_bus_obj_tracking
376: BEGIN
377: l_child_rec_exists_no := 0;
378: SELECT child_id INTO l_child_rec_exists_no
379: FROM HZ_BUS_OBJ_TRACKING
375: -- if record not existing, insert into hz_bus_obj_tracking
376: BEGIN
377: l_child_rec_exists_no := 0;
378: SELECT child_id INTO l_child_rec_exists_no
379: FROM HZ_BUS_OBJ_TRACKING
380: WHERE event_id IS NULL
381: AND CHILD_ENTITY_NAME = l_cen
382: AND CHILD_ID = l_child_id
383: AND rownum = 1;
390: END IF;
391: EXCEPTION
392: WHEN NO_DATA_FOUND THEN
393: -- for subject
394: INSERT INTO HZ_BUS_OBJ_TRACKING
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,
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,
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,
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,
412: p_centity_name => 'HZ_PARTIES',
413: p_cbo_code => l_sbo_code,
500: l_lud := c_child_rec.lud;
501: l_child_id := c_child_rec.child_id;
502: l_parent_id := c_child_rec.parent_id;
503:
504: -- if record not existing, insert into hz_bus_obj_tracking
505: BEGIN
506: l_child_rec_exists_no := 0;
507: SELECT child_id INTO l_child_rec_exists_no
508: FROM HZ_BUS_OBJ_TRACKING
504: -- if record not existing, insert into hz_bus_obj_tracking
505: BEGIN
506: l_child_rec_exists_no := 0;
507: SELECT child_id INTO l_child_rec_exists_no
508: FROM HZ_BUS_OBJ_TRACKING
509: WHERE event_id IS NULL
510: AND CHILD_ENTITY_NAME = l_cen
511: AND CHILD_ID = l_child_id
512: AND rownum = 1;
518: p_msg_level=>fnd_log.level_procedure);
519: END IF;
520: EXCEPTION
521: WHEN NO_DATA_FOUND THEN
522: INSERT INTO HZ_BUS_OBJ_TRACKING
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,
601: l_lud := c_child_rec.lud;
602: l_parent_id := c_child_rec.parent_id;
603: l_child_id := c_child_rec.child_id;
604:
605: -- if record not existing, insert into hz_bus_obj_tracking
606: BEGIN
607: l_child_rec_exists_no := 0;
608: SELECT child_id INTO l_child_rec_exists_no
609: FROM HZ_BUS_OBJ_TRACKING
605: -- if record not existing, insert into hz_bus_obj_tracking
606: BEGIN
607: l_child_rec_exists_no := 0;
608: SELECT child_id INTO l_child_rec_exists_no
609: FROM HZ_BUS_OBJ_TRACKING
610: WHERE event_id IS NULL
611: AND CHILD_ENTITY_NAME = l_cen
612: AND CHILD_ID = l_child_id
613: AND rownum = 1;
619: p_msg_level=>fnd_log.level_procedure);
620: END IF;
621: EXCEPTION
622: WHEN NO_DATA_FOUND THEN
623: INSERT INTO HZ_BUS_OBJ_TRACKING
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,
702: l_lud := c_child_rec.lud;
703: l_parent_id := c_child_rec.parent_id;
704: l_child_id := c_child_rec.child_id;
705:
706: -- if record not existing, insert into hz_bus_obj_tracking
707: BEGIN
708: l_child_rec_exists_no := 0;
709: SELECT child_id INTO l_child_rec_exists_no
710: FROM HZ_BUS_OBJ_TRACKING
706: -- if record not existing, insert into hz_bus_obj_tracking
707: BEGIN
708: l_child_rec_exists_no := 0;
709: SELECT child_id INTO l_child_rec_exists_no
710: FROM HZ_BUS_OBJ_TRACKING
711: WHERE event_id IS NULL
712: AND CHILD_ENTITY_NAME = l_cen
713: AND CHILD_ID = l_child_id
714: AND rownum = 1;
720: p_msg_level=>fnd_log.level_procedure);
721: END IF;
722: EXCEPTION
723: WHEN NO_DATA_FOUND THEN
724: INSERT INTO HZ_BUS_OBJ_TRACKING
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,
829: RETURN;
830: END IF;
831: END IF;
832:
833: -- if record not existing, insert into hz_bus_obj_tracking
834: BEGIN
835: l_child_rec_exists_no := 0;
836: SELECT child_id INTO l_child_rec_exists_no
837: FROM HZ_BUS_OBJ_TRACKING
833: -- if record not existing, insert into hz_bus_obj_tracking
834: BEGIN
835: l_child_rec_exists_no := 0;
836: SELECT child_id INTO l_child_rec_exists_no
837: FROM HZ_BUS_OBJ_TRACKING
838: WHERE event_id IS NULL
839: AND CHILD_ENTITY_NAME = l_cen
840: AND CHILD_ID = l_child_id
841: AND rownum = 1;
847: p_msg_level=>fnd_log.level_procedure);
848: END IF;
849: EXCEPTION
850: WHEN NO_DATA_FOUND THEN
851: INSERT INTO HZ_BUS_OBJ_TRACKING
852: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
853: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
854: ) VALUES (
855: 'N', p_operation, l_child_id, 'HZ_PARTY_SITE_USES', NULL,
955: RETURN;
956: END IF;
957: END IF;
958:
959: -- if record not existing, insert into hz_bus_obj_tracking
960: BEGIN
961: l_child_rec_exists_no := 0;
962: SELECT child_id INTO l_child_rec_exists_no
963: FROM HZ_BUS_OBJ_TRACKING
959: -- if record not existing, insert into hz_bus_obj_tracking
960: BEGIN
961: l_child_rec_exists_no := 0;
962: SELECT child_id INTO l_child_rec_exists_no
963: FROM HZ_BUS_OBJ_TRACKING
964: WHERE event_id IS NULL
965: AND CHILD_ENTITY_NAME = l_cen
966: AND CHILD_ID = l_child_id
967: AND rownum = 1;
974: END IF;
975: EXCEPTION
976: WHEN NO_DATA_FOUND THEN
977: -- populate the child bo code also
978: INSERT INTO HZ_BUS_OBJ_TRACKING
979: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
980: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
981: ) VALUES (
982: 'N', p_operation, l_child_id, 'HZ_PARTY_SITES', 'PARTY_SITE',
1055: l_parent_tbl_name := c_child_rec.parent_tbl_name;
1056: l_bo_code := c_child_rec.bo_code;
1057: l_child_id := c_child_rec.child_id;
1058:
1059: -- if record not existing, insert into hz_bus_obj_tracking
1060: BEGIN
1061: l_child_rec_exists_no := 0;
1062: SELECT child_id INTO l_child_rec_exists_no
1063: FROM HZ_BUS_OBJ_TRACKING
1059: -- if record not existing, insert into hz_bus_obj_tracking
1060: BEGIN
1061: l_child_rec_exists_no := 0;
1062: SELECT child_id INTO l_child_rec_exists_no
1063: FROM HZ_BUS_OBJ_TRACKING
1064: WHERE event_id IS NULL
1065: AND CHILD_ENTITY_NAME = l_cen
1066: AND CHILD_ID = l_child_id
1067: AND rownum = 1;
1073: p_msg_level=>fnd_log.level_procedure);
1074: END IF;
1075: EXCEPTION
1076: WHEN NO_DATA_FOUND THEN
1077: INSERT INTO HZ_BUS_OBJ_TRACKING
1078: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
1079: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
1080: ) VALUES (
1081: 'N', p_operation, l_child_id, 'HZ_PARTY_PREFERENCES', NULL,
1162: l_parent_id := c_child_rec.parent_id;
1163: l_child_id := c_child_rec.child_id;
1164: l_org_id := c_child_rec.object_id;
1165:
1166: -- if record not existing, insert into hz_bus_obj_tracking
1167: BEGIN
1168: l_child_rec_exists_no := 0;
1169: SELECT child_id INTO l_child_rec_exists_no
1170: FROM HZ_BUS_OBJ_TRACKING
1166: -- if record not existing, insert into hz_bus_obj_tracking
1167: BEGIN
1168: l_child_rec_exists_no := 0;
1169: SELECT child_id INTO l_child_rec_exists_no
1170: FROM HZ_BUS_OBJ_TRACKING
1171: WHERE event_id IS NULL
1172: AND CHILD_ENTITY_NAME = l_cen
1173: AND CHILD_ID = l_child_id
1174: AND rownum = 1;
1180: p_msg_level=>fnd_log.level_procedure);
1181: END IF;
1182: EXCEPTION
1183: WHEN NO_DATA_FOUND THEN
1184: INSERT INTO HZ_BUS_OBJ_TRACKING
1185: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
1186: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
1187: ) VALUES (
1188: 'N', p_operation, l_child_id, 'HZ_ORG_CONTACT_ROLES', NULL,
1271: l_child_id := c_child_rec.child_id;
1272: l_person_id := c_child_rec.person_id;
1273: l_rel_id := c_child_rec.rel_id;
1274:
1275: -- if record not existing, insert into hz_bus_obj_tracking
1276: BEGIN
1277: l_child_rec_exists_no := 0;
1278: SELECT child_id, populated_flag INTO l_child_rec_exists_no, l_pop_flag
1279: FROM HZ_BUS_OBJ_TRACKING
1275: -- if record not existing, insert into hz_bus_obj_tracking
1276: BEGIN
1277: l_child_rec_exists_no := 0;
1278: SELECT child_id, populated_flag INTO l_child_rec_exists_no, l_pop_flag
1279: FROM HZ_BUS_OBJ_TRACKING
1280: WHERE event_id IS NULL
1281: AND CHILD_ENTITY_NAME = l_cen
1282: AND CHILD_ID = l_child_id
1283: AND rownum = 1;
1283: AND rownum = 1;
1284:
1285: IF l_child_rec_exists_no <> 0 THEN
1286: IF(l_pop_flag = 'Y') THEN
1287: UPDATE HZ_BUS_OBJ_TRACKING
1288: SET populated_flag = 'N'
1289: WHERE event_id IS NULL
1290: AND CHILD_ENTITY_NAME = l_cen
1291: AND CHILD_ID = l_child_id;
1297: END IF;
1298: EXCEPTION
1299: WHEN NO_DATA_FOUND THEN
1300: -- populate the child bo code also
1301: INSERT INTO HZ_BUS_OBJ_TRACKING
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',
1387: l_lud := c_child_rec.lud;
1388: l_parent_id := c_child_rec.parent_id;
1389: l_child_id := c_child_rec.child_id;
1390:
1391: -- if record not existing, insert into hz_bus_obj_tracking
1392: BEGIN
1393: l_child_rec_exists_no := 0;
1394: SELECT child_id INTO l_child_rec_exists_no
1395: FROM HZ_BUS_OBJ_TRACKING
1391: -- if record not existing, insert into hz_bus_obj_tracking
1392: BEGIN
1393: l_child_rec_exists_no := 0;
1394: SELECT child_id INTO l_child_rec_exists_no
1395: FROM HZ_BUS_OBJ_TRACKING
1396: WHERE event_id IS NULL
1397: AND CHILD_ENTITY_NAME = l_cen
1398: AND CHILD_ID = l_child_id
1399: AND rownum = 1;
1405: p_msg_level=>fnd_log.level_procedure);
1406: END IF;
1407: EXCEPTION
1408: WHEN NO_DATA_FOUND THEN
1409: INSERT INTO HZ_BUS_OBJ_TRACKING
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,
1492: FOR c_child_rec IN c_child LOOP
1493: l_lud := c_child_rec.lud;
1494: l_child_id := c_child_rec.child_id;
1495:
1496: -- if record not existing, insert into hz_bus_obj_tracking
1497: BEGIN
1498: l_child_rec_exists_no := 0;
1499: SELECT child_id INTO l_child_rec_exists_no
1500: FROM HZ_BUS_OBJ_TRACKING
1496: -- if record not existing, insert into hz_bus_obj_tracking
1497: BEGIN
1498: l_child_rec_exists_no := 0;
1499: SELECT child_id INTO l_child_rec_exists_no
1500: FROM HZ_BUS_OBJ_TRACKING
1501: WHERE event_id IS NULL
1502: AND CHILD_ENTITY_NAME = l_cen
1503: AND CHILD_ID = l_child_id
1504: AND rownum = 1;
1515: LOOP
1516: FETCH c_ps INTO l_parent_id;
1517: EXIT WHEN c_ps%NOTFOUND;
1518: -- populate the child bo code also
1519: INSERT INTO HZ_BUS_OBJ_TRACKING
1520: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
1521: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
1522: ) VALUES (
1523: 'N', p_operation, l_child_id, 'HZ_LOCATIONS', 'LOCATION',
1596: l_parent_id := c_child_rec.parent_id;
1597: l_bo_code := c_child_rec.bo_code;
1598: l_child_id := c_child_rec.child_id;
1599:
1600: -- if record not existing, insert into hz_bus_obj_tracking
1601: BEGIN
1602: l_child_rec_exists_no := 0;
1603: SELECT child_id, populated_flag INTO l_child_rec_exists_no, l_pop_flag
1604: FROM HZ_BUS_OBJ_TRACKING
1600: -- if record not existing, insert into hz_bus_obj_tracking
1601: BEGIN
1602: l_child_rec_exists_no := 0;
1603: SELECT child_id, populated_flag INTO l_child_rec_exists_no, l_pop_flag
1604: FROM HZ_BUS_OBJ_TRACKING
1605: WHERE event_id IS NULL
1606: AND CHILD_ENTITY_NAME = l_cen
1607: AND CHILD_ID = l_child_id
1608: AND rownum = 1;
1608: AND rownum = 1;
1609:
1610: IF l_child_rec_exists_no <> 0 THEN
1611: IF(l_pop_flag = 'Y') THEN
1612: UPDATE HZ_BUS_OBJ_TRACKING
1613: SET populated_flag = 'N'
1614: WHERE event_id IS NULL
1615: AND CHILD_ENTITY_NAME = l_cen
1616: AND CHILD_ID = l_child_id;
1622: END IF;
1623: EXCEPTION
1624: WHEN NO_DATA_FOUND THEN
1625: -- populate the child bo code also
1626: INSERT INTO HZ_BUS_OBJ_TRACKING
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',
1710: l_parent_id := c_child_rec.parent_id;
1711: l_bo_code := c_child_rec.bo_code;
1712: l_child_id := c_child_rec.child_id;
1713:
1714: -- if record not existing, insert into hz_bus_obj_tracking
1715: BEGIN
1716: l_child_rec_exists_no := 0;
1717: SELECT child_id INTO l_child_rec_exists_no
1718: FROM HZ_BUS_OBJ_TRACKING
1714: -- if record not existing, insert into hz_bus_obj_tracking
1715: BEGIN
1716: l_child_rec_exists_no := 0;
1717: SELECT child_id INTO l_child_rec_exists_no
1718: FROM HZ_BUS_OBJ_TRACKING
1719: WHERE event_id IS NULL
1720: AND CHILD_ENTITY_NAME = l_cen
1721: AND CHILD_ID = l_child_id
1722: AND rownum = 1;
1728: p_msg_level=>fnd_log.level_procedure);
1729: END IF;
1730: EXCEPTION
1731: WHEN NO_DATA_FOUND THEN
1732: INSERT INTO HZ_BUS_OBJ_TRACKING
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,
1815: l_child_id := c_child_rec.child_id;
1816: l_parent_id := c_child_rec.parent_id;
1817: l_party_id := c_child_rec.party_id;
1818:
1819: -- if record not existing, insert into hz_bus_obj_tracking
1820: BEGIN
1821: l_child_rec_exists_no := 0;
1822: SELECT child_id INTO l_child_rec_exists_no
1823: FROM HZ_BUS_OBJ_TRACKING
1819: -- if record not existing, insert into hz_bus_obj_tracking
1820: BEGIN
1821: l_child_rec_exists_no := 0;
1822: SELECT child_id INTO l_child_rec_exists_no
1823: FROM HZ_BUS_OBJ_TRACKING
1824: WHERE event_id IS NULL
1825: AND CHILD_ENTITY_NAME = l_cen
1826: AND CHILD_ID = l_child_id
1827: AND rownum = 1;
1833: p_msg_level=>fnd_log.level_procedure);
1834: END IF;
1835: EXCEPTION
1836: WHEN NO_DATA_FOUND THEN
1837: INSERT INTO HZ_BUS_OBJ_TRACKING
1838: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
1839: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
1840: ) VALUES (
1841: 'N', p_operation, l_child_id, 'HZ_FINANCIAL_NUMBERS', NULL,
1927: l_lud := c_child_rec.lud;
1928: l_child_id := c_child_rec.child_id;
1929: l_parent_id := c_child_rec.parent_id;
1930:
1931: -- if record not existing, insert into hz_bus_obj_tracking
1932: BEGIN
1933: l_child_rec_exists_no := 0;
1934: SELECT child_id, populated_flag INTO l_child_rec_exists_no, l_pop_flag
1935: FROM HZ_BUS_OBJ_TRACKING
1931: -- if record not existing, insert into hz_bus_obj_tracking
1932: BEGIN
1933: l_child_rec_exists_no := 0;
1934: SELECT child_id, populated_flag INTO l_child_rec_exists_no, l_pop_flag
1935: FROM HZ_BUS_OBJ_TRACKING
1936: WHERE event_id IS NULL
1937: AND CHILD_ENTITY_NAME = 'HZ_EMPLOYMENT_HISTORY'
1938: AND CHILD_ID = l_child_id
1939: AND rownum = 1;
1939: AND rownum = 1;
1940:
1941: IF l_child_rec_exists_no <> 0 THEN
1942: IF(l_pop_flag = 'Y') THEN
1943: UPDATE HZ_BUS_OBJ_TRACKING
1944: SET populated_flag = 'N'
1945: WHERE event_id IS NULL
1946: AND CHILD_ENTITY_NAME = l_cen
1947: AND CHILD_ID = l_child_id;
1953: END IF;
1954: EXCEPTION
1955: WHEN NO_DATA_FOUND THEN
1956: -- populate the child bo code also
1957: INSERT INTO HZ_BUS_OBJ_TRACKING
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',
2036: l_lud := c_child_rec.lud;
2037: l_child_id := c_child_rec.child_id;
2038: l_parent_id := c_child_rec.parent_id;
2039:
2040: -- if record not existing, insert into hz_bus_obj_tracking
2041: BEGIN
2042: l_child_rec_exists_no := 0;
2043: SELECT child_id INTO l_child_rec_exists_no
2044: FROM HZ_BUS_OBJ_TRACKING
2040: -- if record not existing, insert into hz_bus_obj_tracking
2041: BEGIN
2042: l_child_rec_exists_no := 0;
2043: SELECT child_id INTO l_child_rec_exists_no
2044: FROM HZ_BUS_OBJ_TRACKING
2045: WHERE event_id IS NULL
2046: AND CHILD_ENTITY_NAME = l_cen
2047: AND CHILD_ID = l_child_id
2048: AND rownum = 1;
2054: p_msg_level=>fnd_log.level_procedure);
2055: END IF;
2056: EXCEPTION
2057: WHEN NO_DATA_FOUND THEN
2058: INSERT INTO HZ_BUS_OBJ_TRACKING
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,
2140: l_child_id := c_child_rec.child_id;
2141: l_parent_id := c_child_rec.parent_id;
2142: l_acct_id := c_child_rec.cust_acct_id;
2143:
2144: -- if record not existing, insert into hz_bus_obj_tracking
2145: BEGIN
2146: l_child_rec_exists_no := 0;
2147: SELECT child_id INTO l_child_rec_exists_no
2148: FROM HZ_BUS_OBJ_TRACKING
2144: -- if record not existing, insert into hz_bus_obj_tracking
2145: BEGIN
2146: l_child_rec_exists_no := 0;
2147: SELECT child_id INTO l_child_rec_exists_no
2148: FROM HZ_BUS_OBJ_TRACKING
2149: WHERE event_id IS NULL
2150: AND CHILD_ENTITY_NAME = l_cen
2151: AND CHILD_ID = l_child_id
2152: AND rownum = 1;
2159: END IF;
2160: EXCEPTION
2161: WHEN NO_DATA_FOUND THEN
2162: -- populate the child bo code also
2163: INSERT INTO HZ_BUS_OBJ_TRACKING
2164: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
2165: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
2166: ) VALUES (
2167: 'N', p_operation, l_child_id, 'HZ_CUST_SITE_USES_ALL', 'CUST_ACCT_SITE_USE',
2243: l_cp_parent_id := c_child_rec.cp_parent_id;
2244: l_cp_parent_entity := c_child_rec.cp_parent_entity;
2245: l_cp_parent_bo := c_child_rec.cp_parent_bo;
2246:
2247: -- if record not existing, insert into hz_bus_obj_tracking
2248: BEGIN
2249: l_child_rec_exists_no := 0;
2250: SELECT child_id INTO l_child_rec_exists_no
2251: FROM HZ_BUS_OBJ_TRACKING
2247: -- if record not existing, insert into hz_bus_obj_tracking
2248: BEGIN
2249: l_child_rec_exists_no := 0;
2250: SELECT child_id INTO l_child_rec_exists_no
2251: FROM HZ_BUS_OBJ_TRACKING
2252: WHERE event_id IS NULL
2253: AND CHILD_ENTITY_NAME = l_cen
2254: AND CHILD_ID = l_child_id
2255: AND rownum = 1;
2261: p_msg_level=>fnd_log.level_procedure);
2262: END IF;
2263: EXCEPTION
2264: WHEN NO_DATA_FOUND THEN
2265: INSERT INTO HZ_BUS_OBJ_TRACKING
2266: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
2267: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
2268: ) VALUES (
2269: 'N', p_operation, l_child_id, 'HZ_CUST_PROFILE_AMTS', NULL,
2353: l_parent_id := c_child_rec.parent_id;
2354: l_ca_parent_id := c_child_rec.ca_parent_id;
2355: l_ca_parent_bo := c_child_rec.ca_parent_bo;
2356:
2357: -- if record not existing, insert into hz_bus_obj_tracking
2358: BEGIN
2359: l_child_rec_exists_no := 0;
2360: SELECT child_id, populated_flag INTO l_child_rec_exists_no, l_pop_flag
2361: FROM HZ_BUS_OBJ_TRACKING
2357: -- if record not existing, insert into hz_bus_obj_tracking
2358: BEGIN
2359: l_child_rec_exists_no := 0;
2360: SELECT child_id, populated_flag INTO l_child_rec_exists_no, l_pop_flag
2361: FROM HZ_BUS_OBJ_TRACKING
2362: WHERE event_id IS NULL
2363: AND CHILD_ENTITY_NAME = l_cen
2364: AND CHILD_ID = l_child_id
2365: AND rownum = 1;
2365: AND rownum = 1;
2366:
2367: IF l_child_rec_exists_no <> 0 THEN
2368: IF(l_pop_flag = 'Y') THEN
2369: UPDATE HZ_BUS_OBJ_TRACKING
2370: SET populated_flag = 'N'
2371: WHERE event_id IS NULL
2372: AND CHILD_ENTITY_NAME = l_cen
2373: AND CHILD_ID = l_child_id;
2379: END IF;
2380: EXCEPTION
2381: WHEN NO_DATA_FOUND THEN
2382: -- populate the child bo code also
2383: INSERT INTO HZ_BUS_OBJ_TRACKING
2384: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
2385: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
2386: ) VALUES (
2387: 'N', p_operation, l_child_id, 'HZ_CUST_ACCT_SITES_ALL', 'CUST_ACCT_SITE',
2476: l_child_id := c_child_rec.child_id;
2477: l_cap_id := c_child_rec.cap_id;
2478: l_rcap_id := c_child_rec.rcap_id;
2479:
2480: -- if record not existing, insert into hz_bus_obj_tracking
2481: BEGIN
2482: l_child_rec_exists_no := 0;
2483: SELECT child_id INTO l_child_rec_exists_no
2484: FROM HZ_BUS_OBJ_TRACKING
2480: -- if record not existing, insert into hz_bus_obj_tracking
2481: BEGIN
2482: l_child_rec_exists_no := 0;
2483: SELECT child_id INTO l_child_rec_exists_no
2484: FROM HZ_BUS_OBJ_TRACKING
2485: WHERE event_id IS NULL
2486: AND CHILD_ENTITY_NAME = l_cen
2487: AND CHILD_ID = l_child_id
2488: AND rownum = 1;
2494: p_msg_level=>fnd_log.level_procedure);
2495: END IF;
2496: EXCEPTION
2497: WHEN NO_DATA_FOUND THEN
2498: INSERT INTO HZ_BUS_OBJ_TRACKING
2499: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
2500: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
2501: ) VALUES (
2502: 'N', p_operation, l_child_id, 'HZ_CUST_ACCT_RELATE_ALL', NULL,
2517: p_parent_id => NULL,
2518: p_pentity_name => NULL,
2519: p_pbo_code => NULL);
2520:
2521: INSERT INTO HZ_BUS_OBJ_TRACKING
2522: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
2523: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
2524: ) VALUES (
2525: 'N', p_operation, l_child_id, 'HZ_CUST_ACCT_RELATE_ALL', NULL,
2620: l_parent_id := c_child_rec.parent_id;
2621: l_parent_bo := c_child_rec.parent_bo;
2622: l_parent_entity := c_child_rec.parent_entity;
2623:
2624: -- if record not existing, insert into hz_bus_obj_tracking
2625: BEGIN
2626: l_child_rec_exists_no := 0;
2627: SELECT child_id, populated_flag INTO l_child_rec_exists_no, l_pop_flag
2628: FROM HZ_BUS_OBJ_TRACKING
2624: -- if record not existing, insert into hz_bus_obj_tracking
2625: BEGIN
2626: l_child_rec_exists_no := 0;
2627: SELECT child_id, populated_flag INTO l_child_rec_exists_no, l_pop_flag
2628: FROM HZ_BUS_OBJ_TRACKING
2629: WHERE event_id IS NULL
2630: AND CHILD_ENTITY_NAME = l_cen
2631: AND CHILD_ID = l_child_id
2632: AND rownum = 1;
2632: AND rownum = 1;
2633:
2634: IF l_child_rec_exists_no <> 0 THEN
2635: IF(l_pop_flag = 'Y') THEN
2636: UPDATE HZ_BUS_OBJ_TRACKING
2637: SET populated_flag = 'N'
2638: WHERE event_id IS NULL
2639: AND CHILD_ENTITY_NAME = l_cen
2640: AND CHILD_ID = l_child_id;
2646: END IF;
2647: EXCEPTION
2648: WHEN NO_DATA_FOUND THEN
2649: -- populate the child bo code also
2650: INSERT INTO HZ_BUS_OBJ_TRACKING
2651: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
2652: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
2653: ) VALUES (
2654: 'N', p_operation, l_child_id, 'HZ_CUST_ACCOUNT_ROLES', 'CUST_ACCT_CONTACT',
2726: l_child_id := c_child_rec.child_id;
2727: l_parent_id := c_child_rec.parent_id;
2728: l_bo_code := c_child_rec.bo_code;
2729:
2730: -- if record not existing, insert into hz_bus_obj_tracking
2731: BEGIN
2732: l_child_rec_exists_no := 0;
2733: SELECT child_id, populated_flag INTO l_child_rec_exists_no, l_pop_flag
2734: FROM HZ_BUS_OBJ_TRACKING
2730: -- if record not existing, insert into hz_bus_obj_tracking
2731: BEGIN
2732: l_child_rec_exists_no := 0;
2733: SELECT child_id, populated_flag INTO l_child_rec_exists_no, l_pop_flag
2734: FROM HZ_BUS_OBJ_TRACKING
2735: WHERE event_id IS NULL
2736: AND CHILD_ENTITY_NAME = l_cen
2737: AND CHILD_ID = l_child_id
2738: AND rownum = 1;
2738: AND rownum = 1;
2739:
2740: IF l_child_rec_exists_no <> 0 THEN
2741: IF(l_pop_flag = 'Y') THEN
2742: UPDATE HZ_BUS_OBJ_TRACKING
2743: SET populated_flag = 'N'
2744: WHERE event_id IS NULL
2745: AND CHILD_ENTITY_NAME = l_cen
2746: AND CHILD_ID = l_child_id;
2752: END IF;
2753: EXCEPTION
2754: WHEN NO_DATA_FOUND THEN
2755: -- populate the child bo code also
2756: INSERT INTO HZ_BUS_OBJ_TRACKING
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',
2838:
2839: -- credit mgmt team create customer profile with customer account id = -1
2840: -- we will not populate bot table for this record
2841: IF(l_parent_id > 0) THEN
2842: -- if record not existing, insert into hz_bus_obj_tracking
2843: BEGIN
2844: l_child_rec_exists_no := 0;
2845: SELECT child_id, populated_flag INTO l_child_rec_exists_no, l_pop_flag
2846: FROM HZ_BUS_OBJ_TRACKING
2842: -- if record not existing, insert into hz_bus_obj_tracking
2843: BEGIN
2844: l_child_rec_exists_no := 0;
2845: SELECT child_id, populated_flag INTO l_child_rec_exists_no, l_pop_flag
2846: FROM HZ_BUS_OBJ_TRACKING
2847: WHERE event_id IS NULL
2848: AND CHILD_ENTITY_NAME = l_cen
2849: AND CHILD_ID = l_child_id
2850: AND rownum = 1;
2850: AND rownum = 1;
2851:
2852: IF l_child_rec_exists_no <> 0 THEN
2853: IF(l_pop_flag = 'Y') THEN
2854: UPDATE HZ_BUS_OBJ_TRACKING
2855: SET populated_flag = 'N'
2856: WHERE event_id IS NULL
2857: AND CHILD_ENTITY_NAME = l_cen
2858: AND CHILD_ID = l_child_id;
2864: END IF;
2865: EXCEPTION
2866: WHEN NO_DATA_FOUND THEN
2867: -- populate the child bo code also
2868: INSERT INTO HZ_BUS_OBJ_TRACKING
2869: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
2870: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
2871: ) VALUES (
2872: 'N', p_operation, l_child_id, 'HZ_CUSTOMER_PROFILES', 'CUST_PROFILE',
2939: l_lud := c_child_rec.lud;
2940: l_child_id := c_child_rec.child_id;
2941: l_parent_id := c_child_rec.parent_id;
2942:
2943: -- if record not existing, insert into hz_bus_obj_tracking
2944: BEGIN
2945: l_child_rec_exists_no := 0;
2946: SELECT child_id INTO l_child_rec_exists_no
2947: FROM HZ_BUS_OBJ_TRACKING
2943: -- if record not existing, insert into hz_bus_obj_tracking
2944: BEGIN
2945: l_child_rec_exists_no := 0;
2946: SELECT child_id INTO l_child_rec_exists_no
2947: FROM HZ_BUS_OBJ_TRACKING
2948: WHERE event_id IS NULL
2949: AND CHILD_ENTITY_NAME = l_cen
2950: AND CHILD_ID = l_child_id
2951: AND rownum = 1;
2957: p_msg_level=>fnd_log.level_procedure);
2958: END IF;
2959: EXCEPTION
2960: WHEN NO_DATA_FOUND THEN
2961: INSERT INTO HZ_BUS_OBJ_TRACKING
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,
3122: END IF;
3123: END IF;
3124: END IF;
3125:
3126: -- if record not existing, insert into hz_bus_obj_tracking
3127: BEGIN
3128: l_child_rec_exists_no := 0;
3129: SELECT child_id INTO l_child_rec_exists_no
3130: FROM HZ_BUS_OBJ_TRACKING
3126: -- if record not existing, insert into hz_bus_obj_tracking
3127: BEGIN
3128: l_child_rec_exists_no := 0;
3129: SELECT child_id INTO l_child_rec_exists_no
3130: FROM HZ_BUS_OBJ_TRACKING
3131: WHERE event_id IS NULL
3132: AND CHILD_ENTITY_NAME = l_cen
3133: AND CHILD_ID = l_child_id
3134: AND rownum = 1;
3140: p_msg_level=>fnd_log.level_procedure);
3141: END IF;
3142: EXCEPTION
3143: WHEN NO_DATA_FOUND THEN
3144: INSERT INTO HZ_BUS_OBJ_TRACKING
3145: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
3146: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
3147: ) VALUES (
3148: 'N', p_operation, l_child_id, 'HZ_CONTACT_PREFERENCES', NULL,
3298: ELSE
3299: NULL;
3300: END CASE;
3301:
3302: -- if record not existing, insert into hz_bus_obj_tracking
3303: BEGIN
3304: l_child_rec_exists_no := 0;
3305: SELECT child_id INTO l_child_rec_exists_no
3306: FROM HZ_BUS_OBJ_TRACKING
3302: -- if record not existing, insert into hz_bus_obj_tracking
3303: BEGIN
3304: l_child_rec_exists_no := 0;
3305: SELECT child_id INTO l_child_rec_exists_no
3306: FROM HZ_BUS_OBJ_TRACKING
3307: WHERE event_id IS NULL
3308: AND CHILD_ENTITY_NAME = l_cen
3309: AND CHILD_ID = l_child_id
3310: AND rownum = 1;
3317: END IF;
3318: EXCEPTION
3319: WHEN NO_DATA_FOUND THEN
3320: -- populate the child bo code also
3321: INSERT INTO HZ_BUS_OBJ_TRACKING
3322: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
3323: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
3324: ) VALUES (
3325: 'N', p_operation, l_child_id, 'HZ_CONTACT_POINTS', l_child_bo_code,
3393: l_child_id := c_child_rec.child_id;
3394: l_parent_id := c_child_rec.parent_id;
3395: l_bo_code := c_child_rec.bo_code;
3396:
3397: -- if record not existing, insert into hz_bus_obj_tracking
3398: BEGIN
3399: l_child_rec_exists_no := 0;
3400: SELECT child_id INTO l_child_rec_exists_no
3401: FROM HZ_BUS_OBJ_TRACKING
3397: -- if record not existing, insert into hz_bus_obj_tracking
3398: BEGIN
3399: l_child_rec_exists_no := 0;
3400: SELECT child_id INTO l_child_rec_exists_no
3401: FROM HZ_BUS_OBJ_TRACKING
3402: WHERE event_id IS NULL
3403: AND CHILD_ENTITY_NAME = l_cen
3404: AND CHILD_ID = l_child_id
3405: AND rownum = 1;
3411: p_msg_level=>fnd_log.level_procedure);
3412: END IF;
3413: EXCEPTION
3414: WHEN NO_DATA_FOUND THEN
3415: INSERT INTO HZ_BUS_OBJ_TRACKING
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,
3493: l_lud := c_child_rec.lud;
3494: l_child_id := c_child_rec.child_id;
3495: l_parent_id := c_child_rec.parent_id;
3496:
3497: -- if record not existing, insert into hz_bus_obj_tracking
3498: BEGIN
3499: l_child_rec_exists_no := 0;
3500: SELECT child_id INTO l_child_rec_exists_no
3501: FROM HZ_BUS_OBJ_TRACKING
3497: -- if record not existing, insert into hz_bus_obj_tracking
3498: BEGIN
3499: l_child_rec_exists_no := 0;
3500: SELECT child_id INTO l_child_rec_exists_no
3501: FROM HZ_BUS_OBJ_TRACKING
3502: WHERE event_id IS NULL
3503: AND CHILD_ENTITY_NAME = l_cen
3504: AND CHILD_ID = l_child_id
3505: AND rownum = 1;
3511: p_msg_level=>fnd_log.level_procedure);
3512: END IF;
3513: EXCEPTION
3514: WHEN NO_DATA_FOUND THEN
3515: INSERT INTO HZ_BUS_OBJ_TRACKING
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,
3596: l_child_id := c_child_rec.child_id;
3597: l_parent_id := c_child_rec.parent_id;
3598: l_bo_code := c_child_rec.bo_code;
3599:
3600: -- if record not existing, insert into hz_bus_obj_tracking
3601: BEGIN
3602: l_child_rec_exists_no := 0;
3603: SELECT child_id INTO l_child_rec_exists_no
3604: FROM HZ_BUS_OBJ_TRACKING
3600: -- if record not existing, insert into hz_bus_obj_tracking
3601: BEGIN
3602: l_child_rec_exists_no := 0;
3603: SELECT child_id INTO l_child_rec_exists_no
3604: FROM HZ_BUS_OBJ_TRACKING
3605: WHERE event_id IS NULL
3606: AND CHILD_ENTITY_NAME = l_cen
3607: AND CHILD_ID = l_child_id
3608: AND rownum = 1;
3614: p_msg_level=>fnd_log.level_procedure);
3615: END IF;
3616: EXCEPTION
3617: WHEN NO_DATA_FOUND THEN
3618: INSERT INTO HZ_BUS_OBJ_TRACKING
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,
3700: l_child_id := c_child_rec.child_id;
3701: l_parent_id := c_child_rec.parent_id;
3702: l_bo_code := c_child_rec.bo_code;
3703:
3704: -- if record not existing, insert into hz_bus_obj_tracking
3705: BEGIN
3706: l_child_rec_exists_no := 0;
3707: SELECT child_id INTO l_child_rec_exists_no
3708: FROM HZ_BUS_OBJ_TRACKING
3704: -- if record not existing, insert into hz_bus_obj_tracking
3705: BEGIN
3706: l_child_rec_exists_no := 0;
3707: SELECT child_id INTO l_child_rec_exists_no
3708: FROM HZ_BUS_OBJ_TRACKING
3709: WHERE event_id IS NULL
3710: AND CHILD_ENTITY_NAME = l_cen
3711: AND CHILD_ID = l_child_id
3712: AND rownum = 1;
3718: p_msg_level=>fnd_log.level_procedure);
3719: END IF;
3720: EXCEPTION
3721: WHEN NO_DATA_FOUND THEN
3722: INSERT INTO HZ_BUS_OBJ_TRACKING
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,
3842: ELSIF(p_object_type = 'PARTY_SITE') THEN
3843: FETCH c_child_ps INTO l_lud, l_parent_id, l_child_id, l_bo_code, l_parent_entity;
3844: END IF;
3845:
3846: -- if record not existing, insert into hz_bus_obj_tracking
3847: BEGIN
3848: l_child_rec_exists_no := 0;
3849: SELECT child_id INTO l_child_rec_exists_no
3850: FROM HZ_BUS_OBJ_TRACKING
3846: -- if record not existing, insert into hz_bus_obj_tracking
3847: BEGIN
3848: l_child_rec_exists_no := 0;
3849: SELECT child_id INTO l_child_rec_exists_no
3850: FROM HZ_BUS_OBJ_TRACKING
3851: WHERE event_id IS NULL
3852: AND CHILD_ENTITY_NAME = l_child_entity
3853: AND CHILD_ID = l_child_id
3854: AND rownum = 1;
3860: p_msg_level=>fnd_log.level_procedure);
3861: END IF;
3862: EXCEPTION
3863: WHEN NO_DATA_FOUND THEN
3864: INSERT INTO HZ_BUS_OBJ_TRACKING
3865: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
3866: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
3867: ) VALUES (
3868: 'N', p_operation, l_child_id, l_child_entity, NULL,
3962: l_g_parent_id := c_child_rec.grand_parent_id;
3963: l_g_parent_tbl_name := c_child_rec.grand_parent_tbl_name;
3964: l_g_parent_bo_code := c_child_rec.grand_parent_bo_code;
3965:
3966: -- if record not existing, insert into hz_bus_obj_tracking
3967: BEGIN
3968: l_child_rec_exists_no := 0;
3969: SELECT child_id INTO l_child_rec_exists_no
3970: FROM HZ_BUS_OBJ_TRACKING
3966: -- if record not existing, insert into hz_bus_obj_tracking
3967: BEGIN
3968: l_child_rec_exists_no := 0;
3969: SELECT child_id INTO l_child_rec_exists_no
3970: FROM HZ_BUS_OBJ_TRACKING
3971: WHERE event_id IS NULL
3972: AND CHILD_ENTITY_NAME = l_cen
3973: AND CHILD_ID = l_child_id
3974: AND rownum = 1;
3980: p_msg_level=>fnd_log.level_procedure);
3981: END IF;
3982: EXCEPTION
3983: WHEN NO_DATA_FOUND THEN
3984: INSERT INTO HZ_BUS_OBJ_TRACKING
3985: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
3986: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
3987: ) VALUES (
3988: 'N', p_operation, l_child_id, 'RA_CUST_RECEIPT_METHODS', NULL,