DBA Data[Home] [Help]

APPS.PO_APPROVALLIST_S1 dependencies on FND_GLOBAL

Line 1130: fnd_global.user_id,

1126: decode(p_approval_list_header_id, NULL, p_first_approver_id, l_old_first_approver_id),
1127: decode(p_approval_list_header_id, NULL, p_approval_path_id, l_old_approval_path_id),
1128: decode(p_approval_list_header_id, NULL, NULL, l_old_wf_item_type),
1129: decode(p_approval_list_header_id, NULL, NULL, l_old_wf_item_key),
1130: fnd_global.user_id,
1131: SYSDATE,
1132: fnd_global.login_id,
1133: fnd_global.user_id,
1134: SYSDATE);

Line 1132: fnd_global.login_id,

1128: decode(p_approval_list_header_id, NULL, NULL, l_old_wf_item_type),
1129: decode(p_approval_list_header_id, NULL, NULL, l_old_wf_item_key),
1130: fnd_global.user_id,
1131: SYSDATE,
1132: fnd_global.login_id,
1133: fnd_global.user_id,
1134: SYSDATE);
1135:
1136: IF (p_approval_list_header_id IS NOT NULL) THEN

Line 1133: fnd_global.user_id,

1129: decode(p_approval_list_header_id, NULL, NULL, l_old_wf_item_key),
1130: fnd_global.user_id,
1131: SYSDATE,
1132: fnd_global.login_id,
1133: fnd_global.user_id,
1134: SYSDATE);
1135:
1136: IF (p_approval_list_header_id IS NOT NULL) THEN
1137: BEGIN

Line 1176: fnd_global.user_id,

1172: approver_type,
1173: status,
1174: response_date,
1175: comments,
1176: fnd_global.user_id,
1177: SYSDATE,
1178: fnd_global.login_id,
1179: fnd_global.user_id,
1180: SYSDATE

Line 1178: fnd_global.login_id,

1174: response_date,
1175: comments,
1176: fnd_global.user_id,
1177: SYSDATE,
1178: fnd_global.login_id,
1179: fnd_global.user_id,
1180: SYSDATE
1181: FROM po_approval_list_lines
1182: WHERE approval_list_header_id = p_approval_list_header_id

Line 1179: fnd_global.user_id,

1175: comments,
1176: fnd_global.user_id,
1177: SYSDATE,
1178: fnd_global.login_id,
1179: fnd_global.user_id,
1180: SYSDATE
1181: FROM po_approval_list_lines
1182: WHERE approval_list_header_id = p_approval_list_header_id
1183: AND sequence_num <= l_old_current_sequence_num;

Line 1238: fnd_global.user_id,

1234: p_approval_list(l_index).approver_type,
1235: NULL, -- status
1236: NULL, -- response_date
1237: NULL, -- comments
1238: fnd_global.user_id,
1239: SYSDATE,
1240: fnd_global.login_id,
1241: fnd_global.user_id,
1242: SYSDATE

Line 1240: fnd_global.login_id,

1236: NULL, -- response_date
1237: NULL, -- comments
1238: fnd_global.user_id,
1239: SYSDATE,
1240: fnd_global.login_id,
1241: fnd_global.user_id,
1242: SYSDATE
1243: FROM sys.dual;
1244: END IF;

Line 1241: fnd_global.user_id,

1237: NULL, -- comments
1238: fnd_global.user_id,
1239: SYSDATE,
1240: fnd_global.login_id,
1241: fnd_global.user_id,
1242: SYSDATE
1243: FROM sys.dual;
1244: END IF;
1245: l_index := p_approval_list.NEXT(l_index);

Line 1254: last_updated_by = fnd_global.user_id,

1250: l_progress := '020';
1251: UPDATE po_approval_list_headers
1252: SET latest_revision = 'N',
1253: last_update_date = SYSDATE,
1254: last_updated_by = fnd_global.user_id,
1255: last_update_login = fnd_global.login_id
1256: WHERE document_id = p_document_id
1257: AND document_type = p_document_type
1258: AND document_subtype = p_document_subtype

Line 1255: last_update_login = fnd_global.login_id

1251: UPDATE po_approval_list_headers
1252: SET latest_revision = 'N',
1253: last_update_date = SYSDATE,
1254: last_updated_by = fnd_global.user_id,
1255: last_update_login = fnd_global.login_id
1256: WHERE document_id = p_document_id
1257: AND document_type = p_document_type
1258: AND document_subtype = p_document_subtype
1259: AND approval_list_header_id = l_old_approval_list_header_id;

Line 1903: fnd_global.user_id,

1899: l_old_first_approver_id,
1900: l_old_approval_path_id,
1901: l_old_wf_item_type2,
1902: l_old_wf_item_key2,
1903: fnd_global.user_id,
1904: SYSDATE,
1905: fnd_global.login_id,
1906: fnd_global.user_id,
1907: SYSDATE);

Line 1905: fnd_global.login_id,

1901: l_old_wf_item_type2,
1902: l_old_wf_item_key2,
1903: fnd_global.user_id,
1904: SYSDATE,
1905: fnd_global.login_id,
1906: fnd_global.user_id,
1907: SYSDATE);
1908:
1909: BEGIN

Line 1906: fnd_global.user_id,

1902: l_old_wf_item_key2,
1903: fnd_global.user_id,
1904: SYSDATE,
1905: fnd_global.login_id,
1906: fnd_global.user_id,
1907: SYSDATE);
1908:
1909: BEGIN
1910: l_progress := '019';

Line 1950: fnd_global.user_id,

1946: approver_type,
1947: status,
1948: response_date,
1949: comments,
1950: fnd_global.user_id,
1951: SYSDATE,
1952: fnd_global.login_id,
1953: fnd_global.user_id,
1954: SYSDATE

Line 1952: fnd_global.login_id,

1948: response_date,
1949: comments,
1950: fnd_global.user_id,
1951: SYSDATE,
1952: fnd_global.login_id,
1953: fnd_global.user_id,
1954: SYSDATE
1955: FROM po_approval_list_lines
1956: WHERE approval_list_header_id = l_old_approval_list_header_id2

Line 1953: fnd_global.user_id,

1949: comments,
1950: fnd_global.user_id,
1951: SYSDATE,
1952: fnd_global.login_id,
1953: fnd_global.user_id,
1954: SYSDATE
1955: FROM po_approval_list_lines
1956: WHERE approval_list_header_id = l_old_approval_list_header_id2
1957: AND sequence_num <= l_old_current_sequence_num;

Line 2022: fnd_global.user_id,

2018: l_complete_approval_list(l_index1).approver_type,
2019: NULL, -- status
2020: NULL, -- response_date
2021: NULL, -- comments
2022: fnd_global.user_id,
2023: SYSDATE,
2024: fnd_global.login_id,
2025: fnd_global.user_id,
2026: SYSDATE

Line 2024: fnd_global.login_id,

2020: NULL, -- response_date
2021: NULL, -- comments
2022: fnd_global.user_id,
2023: SYSDATE,
2024: fnd_global.login_id,
2025: fnd_global.user_id,
2026: SYSDATE
2027: FROM sys.dual;
2028: l_index1 := l_complete_approval_list.NEXT(l_index1);

Line 2025: fnd_global.user_id,

2021: NULL, -- comments
2022: fnd_global.user_id,
2023: SYSDATE,
2024: fnd_global.login_id,
2025: fnd_global.user_id,
2026: SYSDATE
2027: FROM sys.dual;
2028: l_index1 := l_complete_approval_list.NEXT(l_index1);
2029: END IF;

Line 2038: last_updated_by = fnd_global.user_id,

2034:
2035: UPDATE po_approval_list_headers
2036: SET latest_revision = 'N',
2037: last_update_date = SYSDATE,
2038: last_updated_by = fnd_global.user_id,
2039: last_update_login = fnd_global.login_id
2040: WHERE document_id = p_document_id
2041: AND document_type = p_document_type
2042: AND document_subtype = p_document_subtype

Line 2039: last_update_login = fnd_global.login_id

2035: UPDATE po_approval_list_headers
2036: SET latest_revision = 'N',
2037: last_update_date = SYSDATE,
2038: last_updated_by = fnd_global.user_id,
2039: last_update_login = fnd_global.login_id
2040: WHERE document_id = p_document_id
2041: AND document_type = p_document_type
2042: AND document_subtype = p_document_subtype
2043: AND approval_list_header_id = l_old_approval_list_header_id2;

Line 2333: last_updated_by = fnd_global.user_id,

2329:
2330: UPDATE po_approval_list_headers
2331: SET current_sequence_num = l_sequence_num,
2332: last_update_date = SYSDATE,
2333: last_updated_by = fnd_global.user_id,
2334: last_update_login = fnd_global.login_id
2335: WHERE document_id = p_document_id
2336: AND document_type = p_document_type
2337: AND document_subtype = p_document_subtype

Line 2334: last_update_login = fnd_global.login_id

2330: UPDATE po_approval_list_headers
2331: SET current_sequence_num = l_sequence_num,
2332: last_update_date = SYSDATE,
2333: last_updated_by = fnd_global.user_id,
2334: last_update_login = fnd_global.login_id
2335: WHERE document_id = p_document_id
2336: AND document_type = p_document_type
2337: AND document_subtype = p_document_subtype
2338: AND approval_list_header_id = l_old_approval_list_header_id;

Line 2416: last_updated_by = fnd_global.user_id,

2412: UPDATE po_approval_list_headers
2413: SET wf_item_type = p_itemtype,
2414: wf_item_key = p_itemkey,
2415: last_update_date = SYSDATE,
2416: last_updated_by = fnd_global.user_id,
2417: last_update_login = fnd_global.login_id
2418: WHERE approval_list_header_id = p_approval_list_header_id;
2419:
2420: p_return_code := E_SUCCESS;

Line 2417: last_update_login = fnd_global.login_id

2413: SET wf_item_type = p_itemtype,
2414: wf_item_key = p_itemkey,
2415: last_update_date = SYSDATE,
2416: last_updated_by = fnd_global.user_id,
2417: last_update_login = fnd_global.login_id
2418: WHERE approval_list_header_id = p_approval_list_header_id;
2419:
2420: p_return_code := E_SUCCESS;
2421:

Line 2501: last_updated_by = fnd_global.user_id,

2497: responder_id = p_responder_id,
2498: response_date = p_response_date,
2499: comments = substrb(p_comments,1,480),
2500: last_update_date = SYSDATE,
2501: last_updated_by = fnd_global.user_id,
2502: last_update_login = fnd_global.login_id
2503: WHERE approval_list_line_id = l_approval_list_line_id;
2504:
2505: UPDATE po_approval_list_headers

Line 2502: last_update_login = fnd_global.login_id

2498: response_date = p_response_date,
2499: comments = substrb(p_comments,1,480),
2500: last_update_date = SYSDATE,
2501: last_updated_by = fnd_global.user_id,
2502: last_update_login = fnd_global.login_id
2503: WHERE approval_list_line_id = l_approval_list_line_id;
2504:
2505: UPDATE po_approval_list_headers
2506: SET last_update_date = SYSDATE,

Line 2507: last_updated_by = fnd_global.user_id,

2503: WHERE approval_list_line_id = l_approval_list_line_id;
2504:
2505: UPDATE po_approval_list_headers
2506: SET last_update_date = SYSDATE,
2507: last_updated_by = fnd_global.user_id,
2508: last_update_login = fnd_global.login_id
2509: WHERE approval_list_header_id = l_approval_list_header_id;
2510:
2511: ELSE

Line 2508: last_update_login = fnd_global.login_id

2504:
2505: UPDATE po_approval_list_headers
2506: SET last_update_date = SYSDATE,
2507: last_updated_by = fnd_global.user_id,
2508: last_update_login = fnd_global.login_id
2509: WHERE approval_list_header_id = l_approval_list_header_id;
2510:
2511: ELSE
2512:

Line 2553: fnd_global.user_id,

2549: 'FORWARD',
2550: 'FORWARD',
2551: SYSDATE,
2552: '',
2553: fnd_global.user_id,
2554: SYSDATE,
2555: fnd_global.login_id,
2556: fnd_global.user_id,
2557: SYSDATE

Line 2555: fnd_global.login_id,

2551: SYSDATE,
2552: '',
2553: fnd_global.user_id,
2554: SYSDATE,
2555: fnd_global.login_id,
2556: fnd_global.user_id,
2557: SYSDATE
2558: );
2559:

Line 2556: fnd_global.user_id,

2552: '',
2553: fnd_global.user_id,
2554: SYSDATE,
2555: fnd_global.login_id,
2556: fnd_global.user_id,
2557: SYSDATE
2558: );
2559:
2560: UPDATE po_approval_list_headers

Line 2563: last_updated_by = fnd_global.user_id,

2559:
2560: UPDATE po_approval_list_headers
2561: SET current_sequence_num = 1,
2562: last_update_date = SYSDATE,
2563: last_updated_by = fnd_global.user_id,
2564: last_update_login = fnd_global.login_id
2565: WHERE approval_list_header_id = l_approval_list_header_id;
2566:
2567: END IF;

Line 2564: last_update_login = fnd_global.login_id

2560: UPDATE po_approval_list_headers
2561: SET current_sequence_num = 1,
2562: last_update_date = SYSDATE,
2563: last_updated_by = fnd_global.user_id,
2564: last_update_login = fnd_global.login_id
2565: WHERE approval_list_header_id = l_approval_list_header_id;
2566:
2567: END IF;
2568: