259: INSERT INTO hxc_upgrade_status
260: (parent_id,
261: child_id,
262: child_status)
263: VALUES ( FND_GLOBAL.CONC_REQUEST_ID,
264: l_reqtab(l_ind).request_id,
265: 'INCOMPLETE');
266:
267: COMMIT;
342: INSERT INTO hxc_upgrade_status
343: (parent_id,
344: child_id,
345: child_status)
346: VALUES ( FND_GLOBAL.CONC_REQUEST_ID,
347: l_reqtab(l_ind).request_id,
348: 'INCOMPLETE');
349:
350: COMMIT;
425: INSERT INTO hxc_upgrade_status
426: (parent_id,
427: child_id,
428: child_status)
429: VALUES ( FND_GLOBAL.CONC_REQUEST_ID,
430: l_reqtab(l_ind).request_id,
431: 'INCOMPLETE');
432:
433: COMMIT;
501: INSERT INTO hxc_upgrade_status
502: (parent_id,
503: child_id,
504: child_status)
505: VALUES ( FND_GLOBAL.CONC_REQUEST_ID,
506: l_reqtab(l_ind).request_id,
507: 'INCOMPLETE');
508:
509: COMMIT;
600: INSERT INTO hxc_upgrade_status
601: (parent_id,
602: child_id,
603: child_status)
604: VALUES ( FND_GLOBAL.CONC_REQUEST_ID,
605: l_reqtab(l_ind).request_id,
606: 'INCOMPLETE');
607:
608:
674: INSERT INTO hxc_upgrade_status
675: (parent_id,
676: child_id,
677: child_status)
678: VALUES ( FND_GLOBAL.CONC_REQUEST_ID,
679: l_reqtab(l_ind).request_id,
680: 'INCOMPLETE');
681:
682: COMMIT;
722: INSERT INTO hxc_upgrade_status
723: (parent_id,
724: child_id,
725: child_status)
726: VALUES ( FND_GLOBAL.CONC_REQUEST_ID,
727: l_reqtab(l_ind).request_id,
728: 'INCOMPLETE');
729:
730:
796: THEN
797: UPDATE hxc_upgrade_definitions
798: SET status = 'COMPLETE',
799: last_update_date = SYSDATE,
800: last_updated_by = FND_GLOBAL.user_id
801: WHERE upg_type = p_type;
802:
803: put_log('++++++++++++++++++++++++++++++++++++++++++++++++');
804: put_log(upgrade_name(p_type)||' is Complete ');
1181: IF l_complete = TRUE
1182: THEN
1183: UPDATE hxc_upgrade_status
1184: SET child_status = 'COMPLETE'
1185: WHERE child_id = FND_GLOBAL.CONC_REQUEST_ID;
1186:
1187: COMMIT;
1188:
1189: put_log('++++++++++++++++++++++++++++++++++++++++++++++++++++');
1272: IF l_complete = TRUE
1273: THEN
1274: UPDATE hxc_upgrade_status
1275: SET child_status = 'COMPLETE'
1276: WHERE child_id = FND_GLOBAL.CONC_REQUEST_ID;
1277:
1278: COMMIT;
1279:
1280: put_log('++++++++++++++++++++++++++++++++++++++++++++++++++++');
1363: IF l_complete = TRUE
1364: THEN
1365: UPDATE hxc_upgrade_status
1366: SET child_status = 'COMPLETE'
1367: WHERE child_id = FND_GLOBAL.CONC_REQUEST_ID;
1368:
1369: COMMIT;
1370:
1371: put_log('++++++++++++++++++++++++++++++++++++++++++++++++++++');
1493: IF l_complete = TRUE
1494: THEN
1495: UPDATE hxc_upgrade_status
1496: SET child_status = 'COMPLETE'
1497: WHERE child_id = FND_GLOBAL.CONC_REQUEST_ID;
1498:
1499: COMMIT;
1500:
1501: put_log('++++++++++++++++++++++++++++++++++++++++++++++++++++');
1677: IF l_complete = TRUE
1678: THEN
1679: UPDATE hxc_upgrade_status
1680: SET child_status = 'COMPLETE'
1681: WHERE child_id = FND_GLOBAL.CONC_REQUEST_ID;
1682:
1683: COMMIT;
1684:
1685: put_log('++++++++++++++++++++++++++++++++++++++++++++++++++++');
1791: IF l_complete = TRUE
1792: THEN
1793: UPDATE hxc_upgrade_status
1794: SET child_status = 'COMPLETE'
1795: WHERE child_id = FND_GLOBAL.CONC_REQUEST_ID;
1796:
1797: COMMIT;
1798:
1799: put_log('++++++++++++++++++++++++++++++++++++++++++++++++++++');
1889: last_update_date)
1890: VALUES
1891: ( p_upg_type,
1892: 'INCOMPLETE',
1893: FND_GLOBAL.user_id,
1894: SYSDATE);
1895:
1896: END insert_into_upg_defn;
1897: -- stop