eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on FND_GLOBAL

Line 1157: last_updated_by = FND_GLOBAL.user_id,

1153: FORALL i IN 1..l_update_item_id_tbl.COUNT
1154: UPDATE mtl_system_items
1155: SET description = l_update_item_desc_tbl(i),
1156: last_update_date = sysdate,
1157: last_updated_by = FND_GLOBAL.user_id,
1158: last_update_login = FND_GLOBAL.login_id,
1159: request_id = FND_GLOBAL.conc_request_id,
1160: program_application_id = FND_GLOBAL.prog_appl_id,
1161: program_id = FND_GLOBAL.conc_program_id,

Line 1158: last_update_login = FND_GLOBAL.login_id,

1154: UPDATE mtl_system_items
1155: SET description = l_update_item_desc_tbl(i),
1156: last_update_date = sysdate,
1157: last_updated_by = FND_GLOBAL.user_id,
1158: last_update_login = FND_GLOBAL.login_id,
1159: request_id = FND_GLOBAL.conc_request_id,
1160: program_application_id = FND_GLOBAL.prog_appl_id,
1161: program_id = FND_GLOBAL.conc_program_id,
1162: program_update_date = sysdate

Line 1159: request_id = FND_GLOBAL.conc_request_id,

1155: SET description = l_update_item_desc_tbl(i),
1156: last_update_date = sysdate,
1157: last_updated_by = FND_GLOBAL.user_id,
1158: last_update_login = FND_GLOBAL.login_id,
1159: request_id = FND_GLOBAL.conc_request_id,
1160: program_application_id = FND_GLOBAL.prog_appl_id,
1161: program_id = FND_GLOBAL.conc_program_id,
1162: program_update_date = sysdate
1163: WHERE inventory_item_id = l_update_item_id_tbl(i)

Line 1160: program_application_id = FND_GLOBAL.prog_appl_id,

1156: last_update_date = sysdate,
1157: last_updated_by = FND_GLOBAL.user_id,
1158: last_update_login = FND_GLOBAL.login_id,
1159: request_id = FND_GLOBAL.conc_request_id,
1160: program_application_id = FND_GLOBAL.prog_appl_id,
1161: program_id = FND_GLOBAL.conc_program_id,
1162: program_update_date = sysdate
1163: WHERE inventory_item_id = l_update_item_id_tbl(i)
1164: AND organization_id = PO_PDOI_PARAMS.g_sys.master_inv_org_id;

Line 1161: program_id = FND_GLOBAL.conc_program_id,

1157: last_updated_by = FND_GLOBAL.user_id,
1158: last_update_login = FND_GLOBAL.login_id,
1159: request_id = FND_GLOBAL.conc_request_id,
1160: program_application_id = FND_GLOBAL.prog_appl_id,
1161: program_id = FND_GLOBAL.conc_program_id,
1162: program_update_date = sysdate
1163: WHERE inventory_item_id = l_update_item_id_tbl(i)
1164: AND organization_id = PO_PDOI_PARAMS.g_sys.master_inv_org_id;
1165:

Line 1197: last_updated_by = FND_GLOBAL.user_id,

1193: un_number_id = l_un_number_id_tbl(i),
1194: hazard_class_id = l_hazard_class_id_tbl(i),
1195: -- Bug 13506679
1196: last_update_date = sysdate,
1197: last_updated_by = FND_GLOBAL.user_id,
1198: last_update_login = FND_GLOBAL.login_id,
1199: request_id = FND_GLOBAL.conc_request_id,
1200: program_application_id = FND_GLOBAL.prog_appl_id,
1201: program_id = FND_GLOBAL.conc_program_id,

Line 1198: last_update_login = FND_GLOBAL.login_id,

1194: hazard_class_id = l_hazard_class_id_tbl(i),
1195: -- Bug 13506679
1196: last_update_date = sysdate,
1197: last_updated_by = FND_GLOBAL.user_id,
1198: last_update_login = FND_GLOBAL.login_id,
1199: request_id = FND_GLOBAL.conc_request_id,
1200: program_application_id = FND_GLOBAL.prog_appl_id,
1201: program_id = FND_GLOBAL.conc_program_id,
1202: program_update_date = sysdate

Line 1199: request_id = FND_GLOBAL.conc_request_id,

1195: -- Bug 13506679
1196: last_update_date = sysdate,
1197: last_updated_by = FND_GLOBAL.user_id,
1198: last_update_login = FND_GLOBAL.login_id,
1199: request_id = FND_GLOBAL.conc_request_id,
1200: program_application_id = FND_GLOBAL.prog_appl_id,
1201: program_id = FND_GLOBAL.conc_program_id,
1202: program_update_date = sysdate
1203: WHERE po_line_id = l_po_line_id_tbl(i)

Line 1200: program_application_id = FND_GLOBAL.prog_appl_id,

1196: last_update_date = sysdate,
1197: last_updated_by = FND_GLOBAL.user_id,
1198: last_update_login = FND_GLOBAL.login_id,
1199: request_id = FND_GLOBAL.conc_request_id,
1200: program_application_id = FND_GLOBAL.prog_appl_id,
1201: program_id = FND_GLOBAL.conc_program_id,
1202: program_update_date = sysdate
1203: WHERE po_line_id = l_po_line_id_tbl(i)
1204: AND draft_id = l_draft_id_tbl(i);

Line 1201: program_id = FND_GLOBAL.conc_program_id,

1197: last_updated_by = FND_GLOBAL.user_id,
1198: last_update_login = FND_GLOBAL.login_id,
1199: request_id = FND_GLOBAL.conc_request_id,
1200: program_application_id = FND_GLOBAL.prog_appl_id,
1201: program_id = FND_GLOBAL.conc_program_id,
1202: program_update_date = sysdate
1203: WHERE po_line_id = l_po_line_id_tbl(i)
1204: AND draft_id = l_draft_id_tbl(i);
1205:

Line 2444: FND_GLOBAL.user_id,

2440: 'N', -- prevent_encumbrance_flag
2441: 'AGREEMENT', -- distribution_type
2442: p_headers.amount_to_encumber_tbl(i),
2443: sysdate,
2444: FND_GLOBAL.user_id,
2445: FND_GLOBAL.login_id,
2446: sysdate,
2447: FND_GLOBAL.user_id,
2448: FND_GLOBAL.conc_request_id,

Line 2445: FND_GLOBAL.login_id,

2441: 'AGREEMENT', -- distribution_type
2442: p_headers.amount_to_encumber_tbl(i),
2443: sysdate,
2444: FND_GLOBAL.user_id,
2445: FND_GLOBAL.login_id,
2446: sysdate,
2447: FND_GLOBAL.user_id,
2448: FND_GLOBAL.conc_request_id,
2449: FND_GLOBAL.prog_appl_id,

Line 2447: FND_GLOBAL.user_id,

2443: sysdate,
2444: FND_GLOBAL.user_id,
2445: FND_GLOBAL.login_id,
2446: sysdate,
2447: FND_GLOBAL.user_id,
2448: FND_GLOBAL.conc_request_id,
2449: FND_GLOBAL.prog_appl_id,
2450: FND_GLOBAL.conc_program_id,
2451: sysdate

Line 2448: FND_GLOBAL.conc_request_id,

2444: FND_GLOBAL.user_id,
2445: FND_GLOBAL.login_id,
2446: sysdate,
2447: FND_GLOBAL.user_id,
2448: FND_GLOBAL.conc_request_id,
2449: FND_GLOBAL.prog_appl_id,
2450: FND_GLOBAL.conc_program_id,
2451: sysdate
2452: FROM DUAL

Line 2449: FND_GLOBAL.prog_appl_id,

2445: FND_GLOBAL.login_id,
2446: sysdate,
2447: FND_GLOBAL.user_id,
2448: FND_GLOBAL.conc_request_id,
2449: FND_GLOBAL.prog_appl_id,
2450: FND_GLOBAL.conc_program_id,
2451: sysdate
2452: FROM DUAL
2453: WHERE p_headers.error_flag_tbl(i) = FND_API.g_FALSE

Line 2450: FND_GLOBAL.conc_program_id,

2446: sysdate,
2447: FND_GLOBAL.user_id,
2448: FND_GLOBAL.conc_request_id,
2449: FND_GLOBAL.prog_appl_id,
2450: FND_GLOBAL.conc_program_id,
2451: sysdate
2452: FROM DUAL
2453: WHERE p_headers.error_flag_tbl(i) = FND_API.g_FALSE
2454: AND p_headers.encumbrance_required_flag_tbl(i) = 'Y';

Line 3483: NVL(last_updated_by, FND_GLOBAL.user_id),

3479: p_price_diffs.min_multiplier_tbl(i),
3480: p_price_diffs.max_multiplier_tbl(i),
3481: p_price_diffs.multiplier_tbl(i),
3482: NVL(last_update_date, sysdate),
3483: NVL(last_updated_by, FND_GLOBAL.user_id),
3484: NVL(last_update_login, FND_GLOBAL.login_id),
3485: NVL(creation_date, sysdate),
3486: NVL(created_by, FND_GLOBAL.user_id)
3487: FROM po_price_diff_interface

Line 3484: NVL(last_update_login, FND_GLOBAL.login_id),

3480: p_price_diffs.max_multiplier_tbl(i),
3481: p_price_diffs.multiplier_tbl(i),
3482: NVL(last_update_date, sysdate),
3483: NVL(last_updated_by, FND_GLOBAL.user_id),
3484: NVL(last_update_login, FND_GLOBAL.login_id),
3485: NVL(creation_date, sysdate),
3486: NVL(created_by, FND_GLOBAL.user_id)
3487: FROM po_price_diff_interface
3488: WHERE price_diff_interface_id = p_price_diffs.intf_price_diff_id_tbl(i)

Line 3486: NVL(created_by, FND_GLOBAL.user_id)

3482: NVL(last_update_date, sysdate),
3483: NVL(last_updated_by, FND_GLOBAL.user_id),
3484: NVL(last_update_login, FND_GLOBAL.login_id),
3485: NVL(creation_date, sysdate),
3486: NVL(created_by, FND_GLOBAL.user_id)
3487: FROM po_price_diff_interface
3488: WHERE price_diff_interface_id = p_price_diffs.intf_price_diff_id_tbl(i)
3489: AND p_price_diffs.error_flag_tbl(i) = FND_API.g_FALSE;
3490:

Line 3862: NVL(LAST_UPDATE_LOGIN, FND_GLOBAL.login_id) AS LAST_UPDATE_LOGIN,

3858: NUM_CAT_ATTRIBUTE49,
3859: NUM_CAT_ATTRIBUTE50,
3860:
3861: -- Bug 4731494: Make WHO columns not-null in Attr/TLP tables
3862: NVL(LAST_UPDATE_LOGIN, FND_GLOBAL.login_id) AS LAST_UPDATE_LOGIN,
3863: NVL(LAST_UPDATED_BY, FND_GLOBAL.user_id) AS LAST_UPDATED_BY,
3864: NVL(LAST_UPDATE_DATE, sysdate) AS LAST_UPDATE_DATE,
3865: NVL(CREATED_BY, FND_GLOBAL.user_id) AS CREATED_BY,
3866: NVL(CREATION_DATE, sysdate) AS CREATION_DATE,

Line 3863: NVL(LAST_UPDATED_BY, FND_GLOBAL.user_id) AS LAST_UPDATED_BY,

3859: NUM_CAT_ATTRIBUTE50,
3860:
3861: -- Bug 4731494: Make WHO columns not-null in Attr/TLP tables
3862: NVL(LAST_UPDATE_LOGIN, FND_GLOBAL.login_id) AS LAST_UPDATE_LOGIN,
3863: NVL(LAST_UPDATED_BY, FND_GLOBAL.user_id) AS LAST_UPDATED_BY,
3864: NVL(LAST_UPDATE_DATE, sysdate) AS LAST_UPDATE_DATE,
3865: NVL(CREATED_BY, FND_GLOBAL.user_id) AS CREATED_BY,
3866: NVL(CREATION_DATE, sysdate) AS CREATION_DATE,
3867:

Line 3865: NVL(CREATED_BY, FND_GLOBAL.user_id) AS CREATED_BY,

3861: -- Bug 4731494: Make WHO columns not-null in Attr/TLP tables
3862: NVL(LAST_UPDATE_LOGIN, FND_GLOBAL.login_id) AS LAST_UPDATE_LOGIN,
3863: NVL(LAST_UPDATED_BY, FND_GLOBAL.user_id) AS LAST_UPDATED_BY,
3864: NVL(LAST_UPDATE_DATE, sysdate) AS LAST_UPDATE_DATE,
3865: NVL(CREATED_BY, FND_GLOBAL.user_id) AS CREATED_BY,
3866: NVL(CREATION_DATE, sysdate) AS CREATION_DATE,
3867:
3868: REQUEST_ID,
3869: PROGRAM_APPLICATION_ID,

Line 4193: LAST_UPDATE_LOGIN = NVL(PAVI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),

4189: NUM_CAT_ATTRIBUTE47 = DECODE(PAVI.NUM_CAT_ATTRIBUTE47, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, NULL, PAVD.NUM_CAT_ATTRIBUTE47, PAVI.NUM_CAT_ATTRIBUTE47),
4190: NUM_CAT_ATTRIBUTE48 = DECODE(PAVI.NUM_CAT_ATTRIBUTE48, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, NULL, PAVD.NUM_CAT_ATTRIBUTE48, PAVI.NUM_CAT_ATTRIBUTE48),
4191: NUM_CAT_ATTRIBUTE49 = DECODE(PAVI.NUM_CAT_ATTRIBUTE49, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, NULL, PAVD.NUM_CAT_ATTRIBUTE49, PAVI.NUM_CAT_ATTRIBUTE49),
4192: NUM_CAT_ATTRIBUTE50 = DECODE(PAVI.NUM_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, NULL, PAVD.NUM_CAT_ATTRIBUTE50, PAVI.NUM_CAT_ATTRIBUTE50),
4193: LAST_UPDATE_LOGIN = NVL(PAVI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
4194: LAST_UPDATED_BY = NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
4195: LAST_UPDATE_DATE = NVL(PAVI.LAST_UPDATE_DATE, sysdate),
4196: REQUEST_ID = NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),
4197: PROGRAM_APPLICATION_ID = NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),

Line 4194: LAST_UPDATED_BY = NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),

4190: NUM_CAT_ATTRIBUTE48 = DECODE(PAVI.NUM_CAT_ATTRIBUTE48, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, NULL, PAVD.NUM_CAT_ATTRIBUTE48, PAVI.NUM_CAT_ATTRIBUTE48),
4191: NUM_CAT_ATTRIBUTE49 = DECODE(PAVI.NUM_CAT_ATTRIBUTE49, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, NULL, PAVD.NUM_CAT_ATTRIBUTE49, PAVI.NUM_CAT_ATTRIBUTE49),
4192: NUM_CAT_ATTRIBUTE50 = DECODE(PAVI.NUM_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, NULL, PAVD.NUM_CAT_ATTRIBUTE50, PAVI.NUM_CAT_ATTRIBUTE50),
4193: LAST_UPDATE_LOGIN = NVL(PAVI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
4194: LAST_UPDATED_BY = NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
4195: LAST_UPDATE_DATE = NVL(PAVI.LAST_UPDATE_DATE, sysdate),
4196: REQUEST_ID = NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),
4197: PROGRAM_APPLICATION_ID = NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
4198: PROGRAM_ID = NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),

Line 4196: REQUEST_ID = NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),

4192: NUM_CAT_ATTRIBUTE50 = DECODE(PAVI.NUM_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, NULL, PAVD.NUM_CAT_ATTRIBUTE50, PAVI.NUM_CAT_ATTRIBUTE50),
4193: LAST_UPDATE_LOGIN = NVL(PAVI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
4194: LAST_UPDATED_BY = NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
4195: LAST_UPDATE_DATE = NVL(PAVI.LAST_UPDATE_DATE, sysdate),
4196: REQUEST_ID = NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),
4197: PROGRAM_APPLICATION_ID = NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
4198: PROGRAM_ID = NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
4199: PROGRAM_UPDATE_DATE = NVL(PAVI.PROGRAM_UPDATE_DATE, sysdate),
4200: PICTURE = DECODE(PAVI.PICTURE, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, NULL, PAVD.PICTURE, PAVI.PICTURE)

Line 4197: PROGRAM_APPLICATION_ID = NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),

4193: LAST_UPDATE_LOGIN = NVL(PAVI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
4194: LAST_UPDATED_BY = NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
4195: LAST_UPDATE_DATE = NVL(PAVI.LAST_UPDATE_DATE, sysdate),
4196: REQUEST_ID = NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),
4197: PROGRAM_APPLICATION_ID = NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
4198: PROGRAM_ID = NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
4199: PROGRAM_UPDATE_DATE = NVL(PAVI.PROGRAM_UPDATE_DATE, sysdate),
4200: PICTURE = DECODE(PAVI.PICTURE, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, NULL, PAVD.PICTURE, PAVI.PICTURE)
4201: WHEN NOT MATCHED THEN

Line 4198: PROGRAM_ID = NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),

4194: LAST_UPDATED_BY = NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
4195: LAST_UPDATE_DATE = NVL(PAVI.LAST_UPDATE_DATE, sysdate),
4196: REQUEST_ID = NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),
4197: PROGRAM_APPLICATION_ID = NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
4198: PROGRAM_ID = NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
4199: PROGRAM_UPDATE_DATE = NVL(PAVI.PROGRAM_UPDATE_DATE, sysdate),
4200: PICTURE = DECODE(PAVI.PICTURE, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, NULL, PAVD.PICTURE, PAVI.PICTURE)
4201: WHEN NOT MATCHED THEN
4202: INSERT

Line 4853: NVL(PAVI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),

4849: DECODE(PAVI.NUM_CAT_ATTRIBUTE47, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, PAVI.NUM_CAT_ATTRIBUTE47),
4850: DECODE(PAVI.NUM_CAT_ATTRIBUTE48, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, PAVI.NUM_CAT_ATTRIBUTE48),
4851: DECODE(PAVI.NUM_CAT_ATTRIBUTE49, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, PAVI.NUM_CAT_ATTRIBUTE49),
4852: DECODE(PAVI.NUM_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, PAVI.NUM_CAT_ATTRIBUTE50),
4853: NVL(PAVI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
4854: NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
4855: NVL(PAVI.LAST_UPDATE_DATE, sysdate),
4856: NVL(PAVI.CREATED_BY, FND_GLOBAL.user_id),
4857: NVL(PAVI.CREATION_DATE, sysdate),

Line 4854: NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),

4850: DECODE(PAVI.NUM_CAT_ATTRIBUTE48, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, PAVI.NUM_CAT_ATTRIBUTE48),
4851: DECODE(PAVI.NUM_CAT_ATTRIBUTE49, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, PAVI.NUM_CAT_ATTRIBUTE49),
4852: DECODE(PAVI.NUM_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, PAVI.NUM_CAT_ATTRIBUTE50),
4853: NVL(PAVI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
4854: NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
4855: NVL(PAVI.LAST_UPDATE_DATE, sysdate),
4856: NVL(PAVI.CREATED_BY, FND_GLOBAL.user_id),
4857: NVL(PAVI.CREATION_DATE, sysdate),
4858: NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),

Line 4856: NVL(PAVI.CREATED_BY, FND_GLOBAL.user_id),

4852: DECODE(PAVI.NUM_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, PAVI.NUM_CAT_ATTRIBUTE50),
4853: NVL(PAVI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
4854: NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
4855: NVL(PAVI.LAST_UPDATE_DATE, sysdate),
4856: NVL(PAVI.CREATED_BY, FND_GLOBAL.user_id),
4857: NVL(PAVI.CREATION_DATE, sysdate),
4858: NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),
4859: NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
4860: NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),

Line 4858: NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),

4854: NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
4855: NVL(PAVI.LAST_UPDATE_DATE, sysdate),
4856: NVL(PAVI.CREATED_BY, FND_GLOBAL.user_id),
4857: NVL(PAVI.CREATION_DATE, sysdate),
4858: NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),
4859: NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
4860: NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
4861: NVL(PAVI.PROGRAM_UPDATE_DATE, sysdate),
4862: DECODE(PAVI.PICTURE, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVI.PICTURE));

Line 4859: NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),

4855: NVL(PAVI.LAST_UPDATE_DATE, sysdate),
4856: NVL(PAVI.CREATED_BY, FND_GLOBAL.user_id),
4857: NVL(PAVI.CREATION_DATE, sysdate),
4858: NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),
4859: NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
4860: NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
4861: NVL(PAVI.PROGRAM_UPDATE_DATE, sysdate),
4862: DECODE(PAVI.PICTURE, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVI.PICTURE));
4863:

Line 4860: NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),

4856: NVL(PAVI.CREATED_BY, FND_GLOBAL.user_id),
4857: NVL(PAVI.CREATION_DATE, sysdate),
4858: NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),
4859: NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
4860: NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
4861: NVL(PAVI.PROGRAM_UPDATE_DATE, sysdate),
4862: DECODE(PAVI.PICTURE, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVI.PICTURE));
4863:
4864: IF (PO_LOG.d_proc) THEN

Line 5084: NVL(LAST_UPDATE_LOGIN, FND_GLOBAL.login_id) AS LAST_UPDATE_LOGIN,

5080: TL_TEXT_CAT_ATTRIBUTE49,
5081: TL_TEXT_CAT_ATTRIBUTE50,
5082:
5083: -- Bug 4731494: Make WHO columns not-null in Attr/TLP tables
5084: NVL(LAST_UPDATE_LOGIN, FND_GLOBAL.login_id) AS LAST_UPDATE_LOGIN,
5085: NVL(LAST_UPDATED_BY, FND_GLOBAL.user_id) AS LAST_UPDATED_BY,
5086: NVL(LAST_UPDATE_DATE, sysdate) AS LAST_UPDATE_DATE,
5087: NVL(CREATED_BY, FND_GLOBAL.user_id) AS CREATED_BY,
5088: NVL(CREATION_DATE, sysdate) AS CREATION_DATE,

Line 5085: NVL(LAST_UPDATED_BY, FND_GLOBAL.user_id) AS LAST_UPDATED_BY,

5081: TL_TEXT_CAT_ATTRIBUTE50,
5082:
5083: -- Bug 4731494: Make WHO columns not-null in Attr/TLP tables
5084: NVL(LAST_UPDATE_LOGIN, FND_GLOBAL.login_id) AS LAST_UPDATE_LOGIN,
5085: NVL(LAST_UPDATED_BY, FND_GLOBAL.user_id) AS LAST_UPDATED_BY,
5086: NVL(LAST_UPDATE_DATE, sysdate) AS LAST_UPDATE_DATE,
5087: NVL(CREATED_BY, FND_GLOBAL.user_id) AS CREATED_BY,
5088: NVL(CREATION_DATE, sysdate) AS CREATION_DATE,
5089:

Line 5087: NVL(CREATED_BY, FND_GLOBAL.user_id) AS CREATED_BY,

5083: -- Bug 4731494: Make WHO columns not-null in Attr/TLP tables
5084: NVL(LAST_UPDATE_LOGIN, FND_GLOBAL.login_id) AS LAST_UPDATE_LOGIN,
5085: NVL(LAST_UPDATED_BY, FND_GLOBAL.user_id) AS LAST_UPDATED_BY,
5086: NVL(LAST_UPDATE_DATE, sysdate) AS LAST_UPDATE_DATE,
5087: NVL(CREATED_BY, FND_GLOBAL.user_id) AS CREATED_BY,
5088: NVL(CREATION_DATE, sysdate) AS CREATION_DATE,
5089:
5090: REQUEST_ID,
5091: PROGRAM_APPLICATION_ID,

Line 5261: LAST_UPDATE_LOGIN = NVL(PAVTI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),

5257: TL_TEXT_CAT_ATTRIBUTE47 = DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE47, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, NULL, PAVTD.TL_TEXT_CAT_ATTRIBUTE47, PAVTI.TL_TEXT_CAT_ATTRIBUTE47),
5258: TL_TEXT_CAT_ATTRIBUTE48 = DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE48, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, NULL, PAVTD.TL_TEXT_CAT_ATTRIBUTE48, PAVTI.TL_TEXT_CAT_ATTRIBUTE48),
5259: TL_TEXT_CAT_ATTRIBUTE49 = DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE49, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, NULL, PAVTD.TL_TEXT_CAT_ATTRIBUTE49, PAVTI.TL_TEXT_CAT_ATTRIBUTE49),
5260: TL_TEXT_CAT_ATTRIBUTE50 = DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, NULL, PAVTD.TL_TEXT_CAT_ATTRIBUTE50, PAVTI.TL_TEXT_CAT_ATTRIBUTE50),
5261: LAST_UPDATE_LOGIN = NVL(PAVTI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
5262: LAST_UPDATED_BY = NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
5263: LAST_UPDATE_DATE = NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
5264: REQUEST_ID = NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),
5265: PROGRAM_APPLICATION_ID = NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),

Line 5262: LAST_UPDATED_BY = NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),

5258: TL_TEXT_CAT_ATTRIBUTE48 = DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE48, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, NULL, PAVTD.TL_TEXT_CAT_ATTRIBUTE48, PAVTI.TL_TEXT_CAT_ATTRIBUTE48),
5259: TL_TEXT_CAT_ATTRIBUTE49 = DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE49, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, NULL, PAVTD.TL_TEXT_CAT_ATTRIBUTE49, PAVTI.TL_TEXT_CAT_ATTRIBUTE49),
5260: TL_TEXT_CAT_ATTRIBUTE50 = DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, NULL, PAVTD.TL_TEXT_CAT_ATTRIBUTE50, PAVTI.TL_TEXT_CAT_ATTRIBUTE50),
5261: LAST_UPDATE_LOGIN = NVL(PAVTI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
5262: LAST_UPDATED_BY = NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
5263: LAST_UPDATE_DATE = NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
5264: REQUEST_ID = NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),
5265: PROGRAM_APPLICATION_ID = NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
5266: PROGRAM_ID = NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),

Line 5264: REQUEST_ID = NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),

5260: TL_TEXT_CAT_ATTRIBUTE50 = DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, NULL, PAVTD.TL_TEXT_CAT_ATTRIBUTE50, PAVTI.TL_TEXT_CAT_ATTRIBUTE50),
5261: LAST_UPDATE_LOGIN = NVL(PAVTI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
5262: LAST_UPDATED_BY = NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
5263: LAST_UPDATE_DATE = NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
5264: REQUEST_ID = NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),
5265: PROGRAM_APPLICATION_ID = NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
5266: PROGRAM_ID = NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
5267: PROGRAM_UPDATE_DATE = NVL(PAVTI.PROGRAM_UPDATE_DATE, sysdate)
5268: WHEN NOT MATCHED THEN

Line 5265: PROGRAM_APPLICATION_ID = NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),

5261: LAST_UPDATE_LOGIN = NVL(PAVTI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
5262: LAST_UPDATED_BY = NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
5263: LAST_UPDATE_DATE = NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
5264: REQUEST_ID = NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),
5265: PROGRAM_APPLICATION_ID = NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
5266: PROGRAM_ID = NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
5267: PROGRAM_UPDATE_DATE = NVL(PAVTI.PROGRAM_UPDATE_DATE, sysdate)
5268: WHEN NOT MATCHED THEN
5269: INSERT

Line 5266: PROGRAM_ID = NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),

5262: LAST_UPDATED_BY = NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
5263: LAST_UPDATE_DATE = NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
5264: REQUEST_ID = NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),
5265: PROGRAM_APPLICATION_ID = NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
5266: PROGRAM_ID = NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
5267: PROGRAM_UPDATE_DATE = NVL(PAVTI.PROGRAM_UPDATE_DATE, sysdate)
5268: WHEN NOT MATCHED THEN
5269: INSERT
5270: (

Line 5615: NVL(PAVTI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),

5611: DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE47, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.TL_TEXT_CAT_ATTRIBUTE47),
5612: DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE48, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.TL_TEXT_CAT_ATTRIBUTE48),
5613: DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE49, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.TL_TEXT_CAT_ATTRIBUTE49),
5614: DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.TL_TEXT_CAT_ATTRIBUTE50),
5615: NVL(PAVTI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
5616: NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
5617: NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
5618: NVL(PAVTI.CREATED_BY, FND_GLOBAL.user_id),
5619: NVL(PAVTI.CREATION_DATE, sysdate),

Line 5616: NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),

5612: DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE48, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.TL_TEXT_CAT_ATTRIBUTE48),
5613: DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE49, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.TL_TEXT_CAT_ATTRIBUTE49),
5614: DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.TL_TEXT_CAT_ATTRIBUTE50),
5615: NVL(PAVTI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
5616: NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
5617: NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
5618: NVL(PAVTI.CREATED_BY, FND_GLOBAL.user_id),
5619: NVL(PAVTI.CREATION_DATE, sysdate),
5620: NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),

Line 5618: NVL(PAVTI.CREATED_BY, FND_GLOBAL.user_id),

5614: DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.TL_TEXT_CAT_ATTRIBUTE50),
5615: NVL(PAVTI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
5616: NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
5617: NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
5618: NVL(PAVTI.CREATED_BY, FND_GLOBAL.user_id),
5619: NVL(PAVTI.CREATION_DATE, sysdate),
5620: NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),
5621: NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
5622: NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),

Line 5620: NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),

5616: NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
5617: NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
5618: NVL(PAVTI.CREATED_BY, FND_GLOBAL.user_id),
5619: NVL(PAVTI.CREATION_DATE, sysdate),
5620: NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),
5621: NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
5622: NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
5623: NVL(PAVTI.PROGRAM_UPDATE_DATE, sysdate));
5624:

Line 5621: NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),

5617: NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
5618: NVL(PAVTI.CREATED_BY, FND_GLOBAL.user_id),
5619: NVL(PAVTI.CREATION_DATE, sysdate),
5620: NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),
5621: NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
5622: NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
5623: NVL(PAVTI.PROGRAM_UPDATE_DATE, sysdate));
5624:
5625: IF (PO_LOG.d_proc) THEN

Line 5622: NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),

5618: NVL(PAVTI.CREATED_BY, FND_GLOBAL.user_id),
5619: NVL(PAVTI.CREATION_DATE, sysdate),
5620: NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),
5621: NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
5622: NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
5623: NVL(PAVTI.PROGRAM_UPDATE_DATE, sysdate));
5624:
5625: IF (PO_LOG.d_proc) THEN
5626: PO_LOG.proc_end (d_module);

Line 5827: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

5823: NUM_CAT_ATTRIBUTE47 = NULL,
5824: NUM_CAT_ATTRIBUTE48 = NULL,
5825: NUM_CAT_ATTRIBUTE49 = NULL,
5826: NUM_CAT_ATTRIBUTE50 = NULL,
5827: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5828: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5829: LAST_UPDATE_DATE = sysdate,
5830: REQUEST_ID = FND_GLOBAL.conc_request_id,
5831: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

Line 5828: LAST_UPDATED_BY = FND_GLOBAL.user_id,

5824: NUM_CAT_ATTRIBUTE48 = NULL,
5825: NUM_CAT_ATTRIBUTE49 = NULL,
5826: NUM_CAT_ATTRIBUTE50 = NULL,
5827: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5828: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5829: LAST_UPDATE_DATE = sysdate,
5830: REQUEST_ID = FND_GLOBAL.conc_request_id,
5831: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5832: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 5830: REQUEST_ID = FND_GLOBAL.conc_request_id,

5826: NUM_CAT_ATTRIBUTE50 = NULL,
5827: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5828: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5829: LAST_UPDATE_DATE = sysdate,
5830: REQUEST_ID = FND_GLOBAL.conc_request_id,
5831: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5832: PROGRAM_ID = FND_GLOBAL.conc_program_id,
5833: PROGRAM_UPDATE_DATE = sysdate
5834: WHERE attribute_values_id = l_sync_attr_values_id_tbl(i)

Line 5831: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

5827: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5828: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5829: LAST_UPDATE_DATE = sysdate,
5830: REQUEST_ID = FND_GLOBAL.conc_request_id,
5831: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5832: PROGRAM_ID = FND_GLOBAL.conc_program_id,
5833: PROGRAM_UPDATE_DATE = sysdate
5834: WHERE attribute_values_id = l_sync_attr_values_id_tbl(i)
5835: AND draft_id = l_draft_id_tbl(i);

Line 5832: PROGRAM_ID = FND_GLOBAL.conc_program_id,

5828: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5829: LAST_UPDATE_DATE = sysdate,
5830: REQUEST_ID = FND_GLOBAL.conc_request_id,
5831: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5832: PROGRAM_ID = FND_GLOBAL.conc_program_id,
5833: PROGRAM_UPDATE_DATE = sysdate
5834: WHERE attribute_values_id = l_sync_attr_values_id_tbl(i)
5835: AND draft_id = l_draft_id_tbl(i);
5836:

Line 5930: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

5926: TL_TEXT_CAT_ATTRIBUTE47 = NULL,
5927: TL_TEXT_CAT_ATTRIBUTE48 = NULL,
5928: TL_TEXT_CAT_ATTRIBUTE49 = NULL,
5929: TL_TEXT_CAT_ATTRIBUTE50 = NULL,
5930: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5931: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5932: LAST_UPDATE_DATE = sysdate,
5933: REQUEST_ID = FND_GLOBAL.conc_request_id,
5934: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

Line 5931: LAST_UPDATED_BY = FND_GLOBAL.user_id,

5927: TL_TEXT_CAT_ATTRIBUTE48 = NULL,
5928: TL_TEXT_CAT_ATTRIBUTE49 = NULL,
5929: TL_TEXT_CAT_ATTRIBUTE50 = NULL,
5930: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5931: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5932: LAST_UPDATE_DATE = sysdate,
5933: REQUEST_ID = FND_GLOBAL.conc_request_id,
5934: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5935: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 5933: REQUEST_ID = FND_GLOBAL.conc_request_id,

5929: TL_TEXT_CAT_ATTRIBUTE50 = NULL,
5930: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5931: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5932: LAST_UPDATE_DATE = sysdate,
5933: REQUEST_ID = FND_GLOBAL.conc_request_id,
5934: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5935: PROGRAM_ID = FND_GLOBAL.conc_program_id,
5936: PROGRAM_UPDATE_DATE = sysdate
5937: WHERE attribute_values_tlp_id = l_sync_attr_values_tlp_id_tbl(i)

Line 5934: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

5930: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5931: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5932: LAST_UPDATE_DATE = sysdate,
5933: REQUEST_ID = FND_GLOBAL.conc_request_id,
5934: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5935: PROGRAM_ID = FND_GLOBAL.conc_program_id,
5936: PROGRAM_UPDATE_DATE = sysdate
5937: WHERE attribute_values_tlp_id = l_sync_attr_values_tlp_id_tbl(i)
5938: AND draft_id = l_draft_id_tbl(i);

Line 5935: PROGRAM_ID = FND_GLOBAL.conc_program_id,

5931: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5932: LAST_UPDATE_DATE = sysdate,
5933: REQUEST_ID = FND_GLOBAL.conc_request_id,
5934: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5935: PROGRAM_ID = FND_GLOBAL.conc_program_id,
5936: PROGRAM_UPDATE_DATE = sysdate
5937: WHERE attribute_values_tlp_id = l_sync_attr_values_tlp_id_tbl(i)
5938: AND draft_id = l_draft_id_tbl(i);
5939: