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 1066: last_updated_by = FND_GLOBAL.user_id,

1062: FORALL i IN 1..l_update_item_id_tbl.COUNT
1063: UPDATE mtl_system_items
1064: SET description = l_update_item_desc_tbl(i),
1065: last_update_date = sysdate,
1066: last_updated_by = FND_GLOBAL.user_id,
1067: last_update_login = FND_GLOBAL.login_id,
1068: request_id = FND_GLOBAL.conc_request_id,
1069: program_application_id = FND_GLOBAL.prog_appl_id,
1070: program_id = FND_GLOBAL.conc_program_id,

Line 1067: last_update_login = FND_GLOBAL.login_id,

1063: UPDATE mtl_system_items
1064: SET description = l_update_item_desc_tbl(i),
1065: last_update_date = sysdate,
1066: last_updated_by = FND_GLOBAL.user_id,
1067: last_update_login = FND_GLOBAL.login_id,
1068: request_id = FND_GLOBAL.conc_request_id,
1069: program_application_id = FND_GLOBAL.prog_appl_id,
1070: program_id = FND_GLOBAL.conc_program_id,
1071: program_update_date = sysdate

Line 1068: request_id = FND_GLOBAL.conc_request_id,

1064: SET description = l_update_item_desc_tbl(i),
1065: last_update_date = sysdate,
1066: last_updated_by = FND_GLOBAL.user_id,
1067: last_update_login = FND_GLOBAL.login_id,
1068: request_id = FND_GLOBAL.conc_request_id,
1069: program_application_id = FND_GLOBAL.prog_appl_id,
1070: program_id = FND_GLOBAL.conc_program_id,
1071: program_update_date = sysdate
1072: WHERE inventory_item_id = l_update_item_id_tbl(i)

Line 1069: program_application_id = FND_GLOBAL.prog_appl_id,

1065: last_update_date = sysdate,
1066: last_updated_by = FND_GLOBAL.user_id,
1067: last_update_login = FND_GLOBAL.login_id,
1068: request_id = FND_GLOBAL.conc_request_id,
1069: program_application_id = FND_GLOBAL.prog_appl_id,
1070: program_id = FND_GLOBAL.conc_program_id,
1071: program_update_date = sysdate
1072: WHERE inventory_item_id = l_update_item_id_tbl(i)
1073: AND organization_id = PO_PDOI_PARAMS.g_sys.master_inv_org_id;

Line 1070: program_id = FND_GLOBAL.conc_program_id,

1066: last_updated_by = FND_GLOBAL.user_id,
1067: last_update_login = FND_GLOBAL.login_id,
1068: request_id = FND_GLOBAL.conc_request_id,
1069: program_application_id = FND_GLOBAL.prog_appl_id,
1070: program_id = FND_GLOBAL.conc_program_id,
1071: program_update_date = sysdate
1072: WHERE inventory_item_id = l_update_item_id_tbl(i)
1073: AND organization_id = PO_PDOI_PARAMS.g_sys.master_inv_org_id;
1074:

Line 1102: last_updated_by = FND_GLOBAL.user_id,

1098: negotiated_by_preparer_flag = l_negotiated_flag_tbl(i),
1099: category_id = l_category_id_tbl(i),
1100: ip_category_id = l_ip_category_id_tbl(i),
1101: last_update_date = sysdate,
1102: last_updated_by = FND_GLOBAL.user_id,
1103: last_update_login = FND_GLOBAL.login_id,
1104: request_id = FND_GLOBAL.conc_request_id,
1105: program_application_id = FND_GLOBAL.prog_appl_id,
1106: program_id = FND_GLOBAL.conc_program_id,

Line 1103: last_update_login = FND_GLOBAL.login_id,

1099: category_id = l_category_id_tbl(i),
1100: ip_category_id = l_ip_category_id_tbl(i),
1101: last_update_date = sysdate,
1102: last_updated_by = FND_GLOBAL.user_id,
1103: last_update_login = FND_GLOBAL.login_id,
1104: request_id = FND_GLOBAL.conc_request_id,
1105: program_application_id = FND_GLOBAL.prog_appl_id,
1106: program_id = FND_GLOBAL.conc_program_id,
1107: program_update_date = sysdate

Line 1104: request_id = FND_GLOBAL.conc_request_id,

1100: ip_category_id = l_ip_category_id_tbl(i),
1101: last_update_date = sysdate,
1102: last_updated_by = FND_GLOBAL.user_id,
1103: last_update_login = FND_GLOBAL.login_id,
1104: request_id = FND_GLOBAL.conc_request_id,
1105: program_application_id = FND_GLOBAL.prog_appl_id,
1106: program_id = FND_GLOBAL.conc_program_id,
1107: program_update_date = sysdate
1108: WHERE po_line_id = l_po_line_id_tbl(i)

Line 1105: program_application_id = FND_GLOBAL.prog_appl_id,

1101: last_update_date = sysdate,
1102: last_updated_by = FND_GLOBAL.user_id,
1103: last_update_login = FND_GLOBAL.login_id,
1104: request_id = FND_GLOBAL.conc_request_id,
1105: program_application_id = FND_GLOBAL.prog_appl_id,
1106: program_id = FND_GLOBAL.conc_program_id,
1107: program_update_date = sysdate
1108: WHERE po_line_id = l_po_line_id_tbl(i)
1109: AND draft_id = l_draft_id_tbl(i);

Line 1106: program_id = FND_GLOBAL.conc_program_id,

1102: last_updated_by = FND_GLOBAL.user_id,
1103: last_update_login = FND_GLOBAL.login_id,
1104: request_id = FND_GLOBAL.conc_request_id,
1105: program_application_id = FND_GLOBAL.prog_appl_id,
1106: program_id = FND_GLOBAL.conc_program_id,
1107: program_update_date = sysdate
1108: WHERE po_line_id = l_po_line_id_tbl(i)
1109: AND draft_id = l_draft_id_tbl(i);
1110:

Line 2208: FND_GLOBAL.user_id,

2204: 'N', -- prevent_encumbrance_flag
2205: 'AGREEMENT', -- distribution_type
2206: p_headers.amount_to_encumber_tbl(i),
2207: sysdate,
2208: FND_GLOBAL.user_id,
2209: FND_GLOBAL.login_id,
2210: sysdate,
2211: FND_GLOBAL.user_id,
2212: FND_GLOBAL.conc_request_id,

Line 2209: FND_GLOBAL.login_id,

2205: 'AGREEMENT', -- distribution_type
2206: p_headers.amount_to_encumber_tbl(i),
2207: sysdate,
2208: FND_GLOBAL.user_id,
2209: FND_GLOBAL.login_id,
2210: sysdate,
2211: FND_GLOBAL.user_id,
2212: FND_GLOBAL.conc_request_id,
2213: FND_GLOBAL.prog_appl_id,

Line 2211: FND_GLOBAL.user_id,

2207: sysdate,
2208: FND_GLOBAL.user_id,
2209: FND_GLOBAL.login_id,
2210: sysdate,
2211: FND_GLOBAL.user_id,
2212: FND_GLOBAL.conc_request_id,
2213: FND_GLOBAL.prog_appl_id,
2214: FND_GLOBAL.conc_program_id,
2215: sysdate

Line 2212: FND_GLOBAL.conc_request_id,

2208: FND_GLOBAL.user_id,
2209: FND_GLOBAL.login_id,
2210: sysdate,
2211: FND_GLOBAL.user_id,
2212: FND_GLOBAL.conc_request_id,
2213: FND_GLOBAL.prog_appl_id,
2214: FND_GLOBAL.conc_program_id,
2215: sysdate
2216: FROM DUAL

Line 2213: FND_GLOBAL.prog_appl_id,

2209: FND_GLOBAL.login_id,
2210: sysdate,
2211: FND_GLOBAL.user_id,
2212: FND_GLOBAL.conc_request_id,
2213: FND_GLOBAL.prog_appl_id,
2214: FND_GLOBAL.conc_program_id,
2215: sysdate
2216: FROM DUAL
2217: WHERE p_headers.error_flag_tbl(i) = FND_API.g_FALSE

Line 2214: FND_GLOBAL.conc_program_id,

2210: sysdate,
2211: FND_GLOBAL.user_id,
2212: FND_GLOBAL.conc_request_id,
2213: FND_GLOBAL.prog_appl_id,
2214: FND_GLOBAL.conc_program_id,
2215: sysdate
2216: FROM DUAL
2217: WHERE p_headers.error_flag_tbl(i) = FND_API.g_FALSE
2218: AND p_headers.encumbrance_required_flag_tbl(i) = 'Y';

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

3139: p_price_diffs.min_multiplier_tbl(i),
3140: p_price_diffs.max_multiplier_tbl(i),
3141: p_price_diffs.multiplier_tbl(i),
3142: NVL(last_update_date, sysdate),
3143: NVL(last_updated_by, FND_GLOBAL.user_id),
3144: NVL(last_update_login, FND_GLOBAL.login_id),
3145: NVL(creation_date, sysdate),
3146: NVL(created_by, FND_GLOBAL.user_id)
3147: FROM po_price_diff_interface

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

3140: p_price_diffs.max_multiplier_tbl(i),
3141: p_price_diffs.multiplier_tbl(i),
3142: NVL(last_update_date, sysdate),
3143: NVL(last_updated_by, FND_GLOBAL.user_id),
3144: NVL(last_update_login, FND_GLOBAL.login_id),
3145: NVL(creation_date, sysdate),
3146: NVL(created_by, FND_GLOBAL.user_id)
3147: FROM po_price_diff_interface
3148: WHERE price_diff_interface_id = p_price_diffs.intf_price_diff_id_tbl(i)

Line 3146: NVL(created_by, FND_GLOBAL.user_id)

3142: NVL(last_update_date, sysdate),
3143: NVL(last_updated_by, FND_GLOBAL.user_id),
3144: NVL(last_update_login, FND_GLOBAL.login_id),
3145: NVL(creation_date, sysdate),
3146: NVL(created_by, FND_GLOBAL.user_id)
3147: FROM po_price_diff_interface
3148: WHERE price_diff_interface_id = p_price_diffs.intf_price_diff_id_tbl(i)
3149: AND p_price_diffs.error_flag_tbl(i) = FND_API.g_FALSE;
3150:

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

3518: NUM_CAT_ATTRIBUTE49,
3519: NUM_CAT_ATTRIBUTE50,
3520:
3521: -- Bug 4731494: Make WHO columns not-null in Attr/TLP tables
3522: NVL(LAST_UPDATE_LOGIN, FND_GLOBAL.login_id) AS LAST_UPDATE_LOGIN,
3523: NVL(LAST_UPDATED_BY, FND_GLOBAL.user_id) AS LAST_UPDATED_BY,
3524: NVL(LAST_UPDATE_DATE, sysdate) AS LAST_UPDATE_DATE,
3525: NVL(CREATED_BY, FND_GLOBAL.user_id) AS CREATED_BY,
3526: NVL(CREATION_DATE, sysdate) AS CREATION_DATE,

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

3519: NUM_CAT_ATTRIBUTE50,
3520:
3521: -- Bug 4731494: Make WHO columns not-null in Attr/TLP tables
3522: NVL(LAST_UPDATE_LOGIN, FND_GLOBAL.login_id) AS LAST_UPDATE_LOGIN,
3523: NVL(LAST_UPDATED_BY, FND_GLOBAL.user_id) AS LAST_UPDATED_BY,
3524: NVL(LAST_UPDATE_DATE, sysdate) AS LAST_UPDATE_DATE,
3525: NVL(CREATED_BY, FND_GLOBAL.user_id) AS CREATED_BY,
3526: NVL(CREATION_DATE, sysdate) AS CREATION_DATE,
3527:

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

3521: -- Bug 4731494: Make WHO columns not-null in Attr/TLP tables
3522: NVL(LAST_UPDATE_LOGIN, FND_GLOBAL.login_id) AS LAST_UPDATE_LOGIN,
3523: NVL(LAST_UPDATED_BY, FND_GLOBAL.user_id) AS LAST_UPDATED_BY,
3524: NVL(LAST_UPDATE_DATE, sysdate) AS LAST_UPDATE_DATE,
3525: NVL(CREATED_BY, FND_GLOBAL.user_id) AS CREATED_BY,
3526: NVL(CREATION_DATE, sysdate) AS CREATION_DATE,
3527:
3528: REQUEST_ID,
3529: PROGRAM_APPLICATION_ID,

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

3849: NUM_CAT_ATTRIBUTE47 = DECODE(PAVI.NUM_CAT_ATTRIBUTE47, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, NULL, PAVD.NUM_CAT_ATTRIBUTE47, PAVI.NUM_CAT_ATTRIBUTE47),
3850: NUM_CAT_ATTRIBUTE48 = DECODE(PAVI.NUM_CAT_ATTRIBUTE48, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, NULL, PAVD.NUM_CAT_ATTRIBUTE48, PAVI.NUM_CAT_ATTRIBUTE48),
3851: NUM_CAT_ATTRIBUTE49 = DECODE(PAVI.NUM_CAT_ATTRIBUTE49, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, NULL, PAVD.NUM_CAT_ATTRIBUTE49, PAVI.NUM_CAT_ATTRIBUTE49),
3852: NUM_CAT_ATTRIBUTE50 = DECODE(PAVI.NUM_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, NULL, PAVD.NUM_CAT_ATTRIBUTE50, PAVI.NUM_CAT_ATTRIBUTE50),
3853: LAST_UPDATE_LOGIN = NVL(PAVI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
3854: LAST_UPDATED_BY = NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
3855: LAST_UPDATE_DATE = NVL(PAVI.LAST_UPDATE_DATE, sysdate),
3856: REQUEST_ID = NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),
3857: PROGRAM_APPLICATION_ID = NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),

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

3850: NUM_CAT_ATTRIBUTE48 = DECODE(PAVI.NUM_CAT_ATTRIBUTE48, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, NULL, PAVD.NUM_CAT_ATTRIBUTE48, PAVI.NUM_CAT_ATTRIBUTE48),
3851: NUM_CAT_ATTRIBUTE49 = DECODE(PAVI.NUM_CAT_ATTRIBUTE49, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, NULL, PAVD.NUM_CAT_ATTRIBUTE49, PAVI.NUM_CAT_ATTRIBUTE49),
3852: NUM_CAT_ATTRIBUTE50 = DECODE(PAVI.NUM_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, NULL, PAVD.NUM_CAT_ATTRIBUTE50, PAVI.NUM_CAT_ATTRIBUTE50),
3853: LAST_UPDATE_LOGIN = NVL(PAVI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
3854: LAST_UPDATED_BY = NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
3855: LAST_UPDATE_DATE = NVL(PAVI.LAST_UPDATE_DATE, sysdate),
3856: REQUEST_ID = NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),
3857: PROGRAM_APPLICATION_ID = NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
3858: PROGRAM_ID = NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),

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

3852: NUM_CAT_ATTRIBUTE50 = DECODE(PAVI.NUM_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, NULL, PAVD.NUM_CAT_ATTRIBUTE50, PAVI.NUM_CAT_ATTRIBUTE50),
3853: LAST_UPDATE_LOGIN = NVL(PAVI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
3854: LAST_UPDATED_BY = NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
3855: LAST_UPDATE_DATE = NVL(PAVI.LAST_UPDATE_DATE, sysdate),
3856: REQUEST_ID = NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),
3857: PROGRAM_APPLICATION_ID = NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
3858: PROGRAM_ID = NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
3859: PROGRAM_UPDATE_DATE = NVL(PAVI.PROGRAM_UPDATE_DATE, sysdate),
3860: PICTURE = DECODE(PAVI.PICTURE, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, NULL, PAVD.PICTURE, PAVI.PICTURE)

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

3853: LAST_UPDATE_LOGIN = NVL(PAVI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
3854: LAST_UPDATED_BY = NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
3855: LAST_UPDATE_DATE = NVL(PAVI.LAST_UPDATE_DATE, sysdate),
3856: REQUEST_ID = NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),
3857: PROGRAM_APPLICATION_ID = NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
3858: PROGRAM_ID = NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
3859: PROGRAM_UPDATE_DATE = NVL(PAVI.PROGRAM_UPDATE_DATE, sysdate),
3860: PICTURE = DECODE(PAVI.PICTURE, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, NULL, PAVD.PICTURE, PAVI.PICTURE)
3861: WHEN NOT MATCHED THEN

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

3854: LAST_UPDATED_BY = NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
3855: LAST_UPDATE_DATE = NVL(PAVI.LAST_UPDATE_DATE, sysdate),
3856: REQUEST_ID = NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),
3857: PROGRAM_APPLICATION_ID = NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
3858: PROGRAM_ID = NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
3859: PROGRAM_UPDATE_DATE = NVL(PAVI.PROGRAM_UPDATE_DATE, sysdate),
3860: PICTURE = DECODE(PAVI.PICTURE, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, NULL, PAVD.PICTURE, PAVI.PICTURE)
3861: WHEN NOT MATCHED THEN
3862: INSERT

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

4509: DECODE(PAVI.NUM_CAT_ATTRIBUTE47, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, PAVI.NUM_CAT_ATTRIBUTE47),
4510: DECODE(PAVI.NUM_CAT_ATTRIBUTE48, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, PAVI.NUM_CAT_ATTRIBUTE48),
4511: DECODE(PAVI.NUM_CAT_ATTRIBUTE49, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, PAVI.NUM_CAT_ATTRIBUTE49),
4512: DECODE(PAVI.NUM_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, PAVI.NUM_CAT_ATTRIBUTE50),
4513: NVL(PAVI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
4514: NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
4515: NVL(PAVI.LAST_UPDATE_DATE, sysdate),
4516: NVL(PAVI.CREATED_BY, FND_GLOBAL.user_id),
4517: NVL(PAVI.CREATION_DATE, sysdate),

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

4510: DECODE(PAVI.NUM_CAT_ATTRIBUTE48, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, PAVI.NUM_CAT_ATTRIBUTE48),
4511: DECODE(PAVI.NUM_CAT_ATTRIBUTE49, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, PAVI.NUM_CAT_ATTRIBUTE49),
4512: DECODE(PAVI.NUM_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, PAVI.NUM_CAT_ATTRIBUTE50),
4513: NVL(PAVI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
4514: NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
4515: NVL(PAVI.LAST_UPDATE_DATE, sysdate),
4516: NVL(PAVI.CREATED_BY, FND_GLOBAL.user_id),
4517: NVL(PAVI.CREATION_DATE, sysdate),
4518: NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),

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

4512: DECODE(PAVI.NUM_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_NUM, NULL, PAVI.NUM_CAT_ATTRIBUTE50),
4513: NVL(PAVI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
4514: NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
4515: NVL(PAVI.LAST_UPDATE_DATE, sysdate),
4516: NVL(PAVI.CREATED_BY, FND_GLOBAL.user_id),
4517: NVL(PAVI.CREATION_DATE, sysdate),
4518: NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),
4519: NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
4520: NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),

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

4514: NVL(PAVI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
4515: NVL(PAVI.LAST_UPDATE_DATE, sysdate),
4516: NVL(PAVI.CREATED_BY, FND_GLOBAL.user_id),
4517: NVL(PAVI.CREATION_DATE, sysdate),
4518: NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),
4519: NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
4520: NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
4521: NVL(PAVI.PROGRAM_UPDATE_DATE, sysdate),
4522: DECODE(PAVI.PICTURE, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVI.PICTURE));

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

4515: NVL(PAVI.LAST_UPDATE_DATE, sysdate),
4516: NVL(PAVI.CREATED_BY, FND_GLOBAL.user_id),
4517: NVL(PAVI.CREATION_DATE, sysdate),
4518: NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),
4519: NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
4520: NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
4521: NVL(PAVI.PROGRAM_UPDATE_DATE, sysdate),
4522: DECODE(PAVI.PICTURE, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVI.PICTURE));
4523:

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

4516: NVL(PAVI.CREATED_BY, FND_GLOBAL.user_id),
4517: NVL(PAVI.CREATION_DATE, sysdate),
4518: NVL(PAVI.REQUEST_ID, FND_GLOBAL.conc_request_id),
4519: NVL(PAVI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
4520: NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
4521: NVL(PAVI.PROGRAM_UPDATE_DATE, sysdate),
4522: DECODE(PAVI.PICTURE, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVI.PICTURE));
4523:
4524: IF (PO_LOG.d_proc) THEN

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

4740: TL_TEXT_CAT_ATTRIBUTE49,
4741: TL_TEXT_CAT_ATTRIBUTE50,
4742:
4743: -- Bug 4731494: Make WHO columns not-null in Attr/TLP tables
4744: NVL(LAST_UPDATE_LOGIN, FND_GLOBAL.login_id) AS LAST_UPDATE_LOGIN,
4745: NVL(LAST_UPDATED_BY, FND_GLOBAL.user_id) AS LAST_UPDATED_BY,
4746: NVL(LAST_UPDATE_DATE, sysdate) AS LAST_UPDATE_DATE,
4747: NVL(CREATED_BY, FND_GLOBAL.user_id) AS CREATED_BY,
4748: NVL(CREATION_DATE, sysdate) AS CREATION_DATE,

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

4741: TL_TEXT_CAT_ATTRIBUTE50,
4742:
4743: -- Bug 4731494: Make WHO columns not-null in Attr/TLP tables
4744: NVL(LAST_UPDATE_LOGIN, FND_GLOBAL.login_id) AS LAST_UPDATE_LOGIN,
4745: NVL(LAST_UPDATED_BY, FND_GLOBAL.user_id) AS LAST_UPDATED_BY,
4746: NVL(LAST_UPDATE_DATE, sysdate) AS LAST_UPDATE_DATE,
4747: NVL(CREATED_BY, FND_GLOBAL.user_id) AS CREATED_BY,
4748: NVL(CREATION_DATE, sysdate) AS CREATION_DATE,
4749:

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

4743: -- Bug 4731494: Make WHO columns not-null in Attr/TLP tables
4744: NVL(LAST_UPDATE_LOGIN, FND_GLOBAL.login_id) AS LAST_UPDATE_LOGIN,
4745: NVL(LAST_UPDATED_BY, FND_GLOBAL.user_id) AS LAST_UPDATED_BY,
4746: NVL(LAST_UPDATE_DATE, sysdate) AS LAST_UPDATE_DATE,
4747: NVL(CREATED_BY, FND_GLOBAL.user_id) AS CREATED_BY,
4748: NVL(CREATION_DATE, sysdate) AS CREATION_DATE,
4749:
4750: REQUEST_ID,
4751: PROGRAM_APPLICATION_ID,

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

4917: 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),
4918: 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),
4919: 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),
4920: 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),
4921: LAST_UPDATE_LOGIN = NVL(PAVTI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
4922: LAST_UPDATED_BY = NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
4923: LAST_UPDATE_DATE = NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
4924: REQUEST_ID = NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),
4925: PROGRAM_APPLICATION_ID = NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),

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

4918: 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),
4919: 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),
4920: 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),
4921: LAST_UPDATE_LOGIN = NVL(PAVTI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
4922: LAST_UPDATED_BY = NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
4923: LAST_UPDATE_DATE = NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
4924: REQUEST_ID = NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),
4925: PROGRAM_APPLICATION_ID = NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
4926: PROGRAM_ID = NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),

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

4920: 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),
4921: LAST_UPDATE_LOGIN = NVL(PAVTI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
4922: LAST_UPDATED_BY = NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
4923: LAST_UPDATE_DATE = NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
4924: REQUEST_ID = NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),
4925: PROGRAM_APPLICATION_ID = NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
4926: PROGRAM_ID = NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
4927: PROGRAM_UPDATE_DATE = NVL(PAVTI.PROGRAM_UPDATE_DATE, sysdate)
4928: WHEN NOT MATCHED THEN

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

4921: LAST_UPDATE_LOGIN = NVL(PAVTI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
4922: LAST_UPDATED_BY = NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
4923: LAST_UPDATE_DATE = NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
4924: REQUEST_ID = NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),
4925: PROGRAM_APPLICATION_ID = NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
4926: PROGRAM_ID = NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
4927: PROGRAM_UPDATE_DATE = NVL(PAVTI.PROGRAM_UPDATE_DATE, sysdate)
4928: WHEN NOT MATCHED THEN
4929: INSERT

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

4922: LAST_UPDATED_BY = NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
4923: LAST_UPDATE_DATE = NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
4924: REQUEST_ID = NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),
4925: PROGRAM_APPLICATION_ID = NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
4926: PROGRAM_ID = NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
4927: PROGRAM_UPDATE_DATE = NVL(PAVTI.PROGRAM_UPDATE_DATE, sysdate)
4928: WHEN NOT MATCHED THEN
4929: INSERT
4930: (

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

5271: DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE47, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.TL_TEXT_CAT_ATTRIBUTE47),
5272: DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE48, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.TL_TEXT_CAT_ATTRIBUTE48),
5273: DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE49, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.TL_TEXT_CAT_ATTRIBUTE49),
5274: DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.TL_TEXT_CAT_ATTRIBUTE50),
5275: NVL(PAVTI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
5276: NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
5277: NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
5278: NVL(PAVTI.CREATED_BY, FND_GLOBAL.user_id),
5279: NVL(PAVTI.CREATION_DATE, sysdate),

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

5272: DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE48, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.TL_TEXT_CAT_ATTRIBUTE48),
5273: DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE49, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.TL_TEXT_CAT_ATTRIBUTE49),
5274: DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.TL_TEXT_CAT_ATTRIBUTE50),
5275: NVL(PAVTI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
5276: NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
5277: NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
5278: NVL(PAVTI.CREATED_BY, FND_GLOBAL.user_id),
5279: NVL(PAVTI.CREATION_DATE, sysdate),
5280: NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),

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

5274: DECODE(PAVTI.TL_TEXT_CAT_ATTRIBUTE50, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVTI.TL_TEXT_CAT_ATTRIBUTE50),
5275: NVL(PAVTI.LAST_UPDATE_LOGIN, FND_GLOBAL.login_id),
5276: NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
5277: NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
5278: NVL(PAVTI.CREATED_BY, FND_GLOBAL.user_id),
5279: NVL(PAVTI.CREATION_DATE, sysdate),
5280: NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),
5281: NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
5282: NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),

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

5276: NVL(PAVTI.LAST_UPDATED_BY, FND_GLOBAL.user_id),
5277: NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
5278: NVL(PAVTI.CREATED_BY, FND_GLOBAL.user_id),
5279: NVL(PAVTI.CREATION_DATE, sysdate),
5280: NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),
5281: NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
5282: NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
5283: NVL(PAVTI.PROGRAM_UPDATE_DATE, sysdate));
5284:

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

5277: NVL(PAVTI.LAST_UPDATE_DATE, sysdate),
5278: NVL(PAVTI.CREATED_BY, FND_GLOBAL.user_id),
5279: NVL(PAVTI.CREATION_DATE, sysdate),
5280: NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),
5281: NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
5282: NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
5283: NVL(PAVTI.PROGRAM_UPDATE_DATE, sysdate));
5284:
5285: IF (PO_LOG.d_proc) THEN

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

5278: NVL(PAVTI.CREATED_BY, FND_GLOBAL.user_id),
5279: NVL(PAVTI.CREATION_DATE, sysdate),
5280: NVL(PAVTI.REQUEST_ID, FND_GLOBAL.conc_request_id),
5281: NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
5282: NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
5283: NVL(PAVTI.PROGRAM_UPDATE_DATE, sysdate));
5284:
5285: IF (PO_LOG.d_proc) THEN
5286: PO_LOG.proc_end (d_module);

Line 5487: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

5483: NUM_CAT_ATTRIBUTE47 = NULL,
5484: NUM_CAT_ATTRIBUTE48 = NULL,
5485: NUM_CAT_ATTRIBUTE49 = NULL,
5486: NUM_CAT_ATTRIBUTE50 = NULL,
5487: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5488: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5489: LAST_UPDATE_DATE = sysdate,
5490: REQUEST_ID = FND_GLOBAL.conc_request_id,
5491: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

Line 5488: LAST_UPDATED_BY = FND_GLOBAL.user_id,

5484: NUM_CAT_ATTRIBUTE48 = NULL,
5485: NUM_CAT_ATTRIBUTE49 = NULL,
5486: NUM_CAT_ATTRIBUTE50 = NULL,
5487: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5488: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5489: LAST_UPDATE_DATE = sysdate,
5490: REQUEST_ID = FND_GLOBAL.conc_request_id,
5491: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5492: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 5490: REQUEST_ID = FND_GLOBAL.conc_request_id,

5486: NUM_CAT_ATTRIBUTE50 = NULL,
5487: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5488: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5489: LAST_UPDATE_DATE = sysdate,
5490: REQUEST_ID = FND_GLOBAL.conc_request_id,
5491: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5492: PROGRAM_ID = FND_GLOBAL.conc_program_id,
5493: PROGRAM_UPDATE_DATE = sysdate
5494: WHERE attribute_values_id = l_sync_attr_values_id_tbl(i)

Line 5491: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

5487: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5488: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5489: LAST_UPDATE_DATE = sysdate,
5490: REQUEST_ID = FND_GLOBAL.conc_request_id,
5491: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5492: PROGRAM_ID = FND_GLOBAL.conc_program_id,
5493: PROGRAM_UPDATE_DATE = sysdate
5494: WHERE attribute_values_id = l_sync_attr_values_id_tbl(i)
5495: AND draft_id = l_draft_id_tbl(i);

Line 5492: PROGRAM_ID = FND_GLOBAL.conc_program_id,

5488: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5489: LAST_UPDATE_DATE = sysdate,
5490: REQUEST_ID = FND_GLOBAL.conc_request_id,
5491: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5492: PROGRAM_ID = FND_GLOBAL.conc_program_id,
5493: PROGRAM_UPDATE_DATE = sysdate
5494: WHERE attribute_values_id = l_sync_attr_values_id_tbl(i)
5495: AND draft_id = l_draft_id_tbl(i);
5496:

Line 5590: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

5586: TL_TEXT_CAT_ATTRIBUTE47 = NULL,
5587: TL_TEXT_CAT_ATTRIBUTE48 = NULL,
5588: TL_TEXT_CAT_ATTRIBUTE49 = NULL,
5589: TL_TEXT_CAT_ATTRIBUTE50 = NULL,
5590: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5591: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5592: LAST_UPDATE_DATE = sysdate,
5593: REQUEST_ID = FND_GLOBAL.conc_request_id,
5594: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

Line 5591: LAST_UPDATED_BY = FND_GLOBAL.user_id,

5587: TL_TEXT_CAT_ATTRIBUTE48 = NULL,
5588: TL_TEXT_CAT_ATTRIBUTE49 = NULL,
5589: TL_TEXT_CAT_ATTRIBUTE50 = NULL,
5590: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5591: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5592: LAST_UPDATE_DATE = sysdate,
5593: REQUEST_ID = FND_GLOBAL.conc_request_id,
5594: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5595: PROGRAM_ID = FND_GLOBAL.conc_program_id,

Line 5593: REQUEST_ID = FND_GLOBAL.conc_request_id,

5589: TL_TEXT_CAT_ATTRIBUTE50 = NULL,
5590: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5591: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5592: LAST_UPDATE_DATE = sysdate,
5593: REQUEST_ID = FND_GLOBAL.conc_request_id,
5594: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5595: PROGRAM_ID = FND_GLOBAL.conc_program_id,
5596: PROGRAM_UPDATE_DATE = sysdate
5597: WHERE attribute_values_tlp_id = l_sync_attr_values_tlp_id_tbl(i)

Line 5594: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,

5590: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
5591: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5592: LAST_UPDATE_DATE = sysdate,
5593: REQUEST_ID = FND_GLOBAL.conc_request_id,
5594: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5595: PROGRAM_ID = FND_GLOBAL.conc_program_id,
5596: PROGRAM_UPDATE_DATE = sysdate
5597: WHERE attribute_values_tlp_id = l_sync_attr_values_tlp_id_tbl(i)
5598: AND draft_id = l_draft_id_tbl(i);

Line 5595: PROGRAM_ID = FND_GLOBAL.conc_program_id,

5591: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5592: LAST_UPDATE_DATE = sysdate,
5593: REQUEST_ID = FND_GLOBAL.conc_request_id,
5594: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,
5595: PROGRAM_ID = FND_GLOBAL.conc_program_id,
5596: PROGRAM_UPDATE_DATE = sysdate
5597: WHERE attribute_values_tlp_id = l_sync_attr_values_tlp_id_tbl(i)
5598: AND draft_id = l_draft_id_tbl(i);
5599: