DBA Data[Home] [Help]

APPS.PO_APPROVALLIST_S1 dependencies on FND_GLOBAL

Line 1151: fnd_global.user_id,

1147: decode(p_approval_list_header_id, NULL, p_first_approver_id, l_old_first_approver_id),
1148: decode(p_approval_list_header_id, NULL, p_approval_path_id, l_old_approval_path_id),
1149: decode(p_approval_list_header_id, NULL, NULL, l_old_wf_item_type),
1150: decode(p_approval_list_header_id, NULL, NULL, l_old_wf_item_key),
1151: fnd_global.user_id,
1152: SYSDATE,
1153: fnd_global.login_id,
1154: fnd_global.user_id,
1155: SYSDATE);

Line 1153: fnd_global.login_id,

1149: decode(p_approval_list_header_id, NULL, NULL, l_old_wf_item_type),
1150: decode(p_approval_list_header_id, NULL, NULL, l_old_wf_item_key),
1151: fnd_global.user_id,
1152: SYSDATE,
1153: fnd_global.login_id,
1154: fnd_global.user_id,
1155: SYSDATE);
1156:
1157: IF (p_approval_list_header_id IS NOT NULL) THEN

Line 1154: fnd_global.user_id,

1150: decode(p_approval_list_header_id, NULL, NULL, l_old_wf_item_key),
1151: fnd_global.user_id,
1152: SYSDATE,
1153: fnd_global.login_id,
1154: fnd_global.user_id,
1155: SYSDATE);
1156:
1157: IF (p_approval_list_header_id IS NOT NULL) THEN
1158: BEGIN

Line 1197: fnd_global.user_id,

1193: approver_type,
1194: status,
1195: response_date,
1196: comments,
1197: fnd_global.user_id,
1198: SYSDATE,
1199: fnd_global.login_id,
1200: fnd_global.user_id,
1201: SYSDATE

Line 1199: fnd_global.login_id,

1195: response_date,
1196: comments,
1197: fnd_global.user_id,
1198: SYSDATE,
1199: fnd_global.login_id,
1200: fnd_global.user_id,
1201: SYSDATE
1202: FROM po_approval_list_lines
1203: WHERE approval_list_header_id = p_approval_list_header_id

Line 1200: fnd_global.user_id,

1196: comments,
1197: fnd_global.user_id,
1198: SYSDATE,
1199: fnd_global.login_id,
1200: fnd_global.user_id,
1201: SYSDATE
1202: FROM po_approval_list_lines
1203: WHERE approval_list_header_id = p_approval_list_header_id
1204: AND sequence_num <= l_old_current_sequence_num;

Line 1259: fnd_global.user_id,

1255: p_approval_list(l_index).approver_type,
1256: NULL, -- status
1257: NULL, -- response_date
1258: NULL, -- comments
1259: fnd_global.user_id,
1260: SYSDATE,
1261: fnd_global.login_id,
1262: fnd_global.user_id,
1263: SYSDATE

Line 1261: fnd_global.login_id,

1257: NULL, -- response_date
1258: NULL, -- comments
1259: fnd_global.user_id,
1260: SYSDATE,
1261: fnd_global.login_id,
1262: fnd_global.user_id,
1263: SYSDATE
1264: FROM sys.dual;
1265: END IF;

Line 1262: fnd_global.user_id,

1258: NULL, -- comments
1259: fnd_global.user_id,
1260: SYSDATE,
1261: fnd_global.login_id,
1262: fnd_global.user_id,
1263: SYSDATE
1264: FROM sys.dual;
1265: END IF;
1266: l_index := p_approval_list.NEXT(l_index);

Line 1275: last_updated_by = fnd_global.user_id,

1271: l_progress := '020';
1272: UPDATE po_approval_list_headers
1273: SET latest_revision = 'N',
1274: last_update_date = SYSDATE,
1275: last_updated_by = fnd_global.user_id,
1276: last_update_login = fnd_global.login_id
1277: WHERE document_id = p_document_id
1278: AND document_type = p_document_type
1279: AND document_subtype = p_document_subtype

Line 1276: last_update_login = fnd_global.login_id

1272: UPDATE po_approval_list_headers
1273: SET latest_revision = 'N',
1274: last_update_date = SYSDATE,
1275: last_updated_by = fnd_global.user_id,
1276: last_update_login = fnd_global.login_id
1277: WHERE document_id = p_document_id
1278: AND document_type = p_document_type
1279: AND document_subtype = p_document_subtype
1280: AND approval_list_header_id = l_old_approval_list_header_id;

Line 1557: fnd_global.user_id,

1553: l_old_current_sequence_num+1,
1554: 'N',
1555: 'N',
1556: 'FORWARD',
1557: fnd_global.user_id,
1558: SYSDATE,
1559: fnd_global.login_id,
1560: fnd_global.user_id,
1561: SYSDATE

Line 1559: fnd_global.login_id,

1555: 'N',
1556: 'FORWARD',
1557: fnd_global.user_id,
1558: SYSDATE,
1559: fnd_global.login_id,
1560: fnd_global.user_id,
1561: SYSDATE
1562: FROM dual;
1563:

Line 1560: fnd_global.user_id,

1556: 'FORWARD',
1557: fnd_global.user_id,
1558: SYSDATE,
1559: fnd_global.login_id,
1560: fnd_global.user_id,
1561: SYSDATE
1562: FROM dual;
1563:
1564:

Line 2015: fnd_global.user_id,

2011: l_old_first_approver_id,
2012: l_old_approval_path_id,
2013: l_old_wf_item_type2,
2014: l_old_wf_item_key2,
2015: fnd_global.user_id,
2016: SYSDATE,
2017: fnd_global.login_id,
2018: fnd_global.user_id,
2019: SYSDATE);

Line 2017: fnd_global.login_id,

2013: l_old_wf_item_type2,
2014: l_old_wf_item_key2,
2015: fnd_global.user_id,
2016: SYSDATE,
2017: fnd_global.login_id,
2018: fnd_global.user_id,
2019: SYSDATE);
2020:
2021: BEGIN

Line 2018: fnd_global.user_id,

2014: l_old_wf_item_key2,
2015: fnd_global.user_id,
2016: SYSDATE,
2017: fnd_global.login_id,
2018: fnd_global.user_id,
2019: SYSDATE);
2020:
2021: BEGIN
2022: l_progress := '019';

Line 2062: fnd_global.user_id,

2058: approver_type,
2059: status,
2060: response_date,
2061: comments,
2062: fnd_global.user_id,
2063: SYSDATE,
2064: fnd_global.login_id,
2065: fnd_global.user_id,
2066: SYSDATE

Line 2064: fnd_global.login_id,

2060: response_date,
2061: comments,
2062: fnd_global.user_id,
2063: SYSDATE,
2064: fnd_global.login_id,
2065: fnd_global.user_id,
2066: SYSDATE
2067: FROM po_approval_list_lines
2068: WHERE approval_list_header_id = l_old_approval_list_header_id2

Line 2065: fnd_global.user_id,

2061: comments,
2062: fnd_global.user_id,
2063: SYSDATE,
2064: fnd_global.login_id,
2065: fnd_global.user_id,
2066: SYSDATE
2067: FROM po_approval_list_lines
2068: WHERE approval_list_header_id = l_old_approval_list_header_id2
2069: AND sequence_num <= l_old_current_sequence_num;

Line 2134: fnd_global.user_id,

2130: l_complete_approval_list(l_index1).approver_type,
2131: NULL, -- status
2132: NULL, -- response_date
2133: NULL, -- comments
2134: fnd_global.user_id,
2135: SYSDATE,
2136: fnd_global.login_id,
2137: fnd_global.user_id,
2138: SYSDATE

Line 2136: fnd_global.login_id,

2132: NULL, -- response_date
2133: NULL, -- comments
2134: fnd_global.user_id,
2135: SYSDATE,
2136: fnd_global.login_id,
2137: fnd_global.user_id,
2138: SYSDATE
2139: FROM sys.dual;
2140: l_index1 := l_complete_approval_list.NEXT(l_index1);

Line 2137: fnd_global.user_id,

2133: NULL, -- comments
2134: fnd_global.user_id,
2135: SYSDATE,
2136: fnd_global.login_id,
2137: fnd_global.user_id,
2138: SYSDATE
2139: FROM sys.dual;
2140: l_index1 := l_complete_approval_list.NEXT(l_index1);
2141: END IF;

Line 2150: last_updated_by = fnd_global.user_id,

2146:
2147: UPDATE po_approval_list_headers
2148: SET latest_revision = 'N',
2149: last_update_date = SYSDATE,
2150: last_updated_by = fnd_global.user_id,
2151: last_update_login = fnd_global.login_id
2152: WHERE document_id = p_document_id
2153: AND document_type = p_document_type
2154: AND document_subtype = p_document_subtype

Line 2151: last_update_login = fnd_global.login_id

2147: UPDATE po_approval_list_headers
2148: SET latest_revision = 'N',
2149: last_update_date = SYSDATE,
2150: last_updated_by = fnd_global.user_id,
2151: last_update_login = fnd_global.login_id
2152: WHERE document_id = p_document_id
2153: AND document_type = p_document_type
2154: AND document_subtype = p_document_subtype
2155: AND approval_list_header_id = l_old_approval_list_header_id2;

Line 2445: last_updated_by = fnd_global.user_id,

2441:
2442: UPDATE po_approval_list_headers
2443: SET current_sequence_num = l_sequence_num,
2444: last_update_date = SYSDATE,
2445: last_updated_by = fnd_global.user_id,
2446: last_update_login = fnd_global.login_id
2447: WHERE document_id = p_document_id
2448: AND document_type = p_document_type
2449: AND document_subtype = p_document_subtype

Line 2446: last_update_login = fnd_global.login_id

2442: UPDATE po_approval_list_headers
2443: SET current_sequence_num = l_sequence_num,
2444: last_update_date = SYSDATE,
2445: last_updated_by = fnd_global.user_id,
2446: last_update_login = fnd_global.login_id
2447: WHERE document_id = p_document_id
2448: AND document_type = p_document_type
2449: AND document_subtype = p_document_subtype
2450: AND approval_list_header_id = l_old_approval_list_header_id;

Line 2528: last_updated_by = fnd_global.user_id,

2524: UPDATE po_approval_list_headers
2525: SET wf_item_type = p_itemtype,
2526: wf_item_key = p_itemkey,
2527: last_update_date = SYSDATE,
2528: last_updated_by = fnd_global.user_id,
2529: last_update_login = fnd_global.login_id
2530: WHERE approval_list_header_id = p_approval_list_header_id;
2531:
2532: p_return_code := E_SUCCESS;

Line 2529: last_update_login = fnd_global.login_id

2525: SET wf_item_type = p_itemtype,
2526: wf_item_key = p_itemkey,
2527: last_update_date = SYSDATE,
2528: last_updated_by = fnd_global.user_id,
2529: last_update_login = fnd_global.login_id
2530: WHERE approval_list_header_id = p_approval_list_header_id;
2531:
2532: p_return_code := E_SUCCESS;
2533:

Line 2613: last_updated_by = fnd_global.user_id,

2609: responder_id = p_responder_id,
2610: response_date = p_response_date,
2611: comments = substrb(p_comments,1,480),
2612: last_update_date = SYSDATE,
2613: last_updated_by = fnd_global.user_id,
2614: last_update_login = fnd_global.login_id
2615: WHERE approval_list_line_id = l_approval_list_line_id;
2616:
2617: UPDATE po_approval_list_headers

Line 2614: last_update_login = fnd_global.login_id

2610: response_date = p_response_date,
2611: comments = substrb(p_comments,1,480),
2612: last_update_date = SYSDATE,
2613: last_updated_by = fnd_global.user_id,
2614: last_update_login = fnd_global.login_id
2615: WHERE approval_list_line_id = l_approval_list_line_id;
2616:
2617: UPDATE po_approval_list_headers
2618: SET last_update_date = SYSDATE,

Line 2619: last_updated_by = fnd_global.user_id,

2615: WHERE approval_list_line_id = l_approval_list_line_id;
2616:
2617: UPDATE po_approval_list_headers
2618: SET last_update_date = SYSDATE,
2619: last_updated_by = fnd_global.user_id,
2620: last_update_login = fnd_global.login_id
2621: WHERE approval_list_header_id = l_approval_list_header_id;
2622:
2623: ELSE

Line 2620: last_update_login = fnd_global.login_id

2616:
2617: UPDATE po_approval_list_headers
2618: SET last_update_date = SYSDATE,
2619: last_updated_by = fnd_global.user_id,
2620: last_update_login = fnd_global.login_id
2621: WHERE approval_list_header_id = l_approval_list_header_id;
2622:
2623: ELSE
2624:

Line 2665: fnd_global.user_id,

2661: 'FORWARD',
2662: 'FORWARD',
2663: SYSDATE,
2664: '',
2665: fnd_global.user_id,
2666: SYSDATE,
2667: fnd_global.login_id,
2668: fnd_global.user_id,
2669: SYSDATE

Line 2667: fnd_global.login_id,

2663: SYSDATE,
2664: '',
2665: fnd_global.user_id,
2666: SYSDATE,
2667: fnd_global.login_id,
2668: fnd_global.user_id,
2669: SYSDATE
2670: );
2671:

Line 2668: fnd_global.user_id,

2664: '',
2665: fnd_global.user_id,
2666: SYSDATE,
2667: fnd_global.login_id,
2668: fnd_global.user_id,
2669: SYSDATE
2670: );
2671:
2672: UPDATE po_approval_list_headers

Line 2675: last_updated_by = fnd_global.user_id,

2671:
2672: UPDATE po_approval_list_headers
2673: SET current_sequence_num = 1,
2674: last_update_date = SYSDATE,
2675: last_updated_by = fnd_global.user_id,
2676: last_update_login = fnd_global.login_id
2677: WHERE approval_list_header_id = l_approval_list_header_id;
2678:
2679: END IF;

Line 2676: last_update_login = fnd_global.login_id

2672: UPDATE po_approval_list_headers
2673: SET current_sequence_num = 1,
2674: last_update_date = SYSDATE,
2675: last_updated_by = fnd_global.user_id,
2676: last_update_login = fnd_global.login_id
2677: WHERE approval_list_header_id = l_approval_list_header_id;
2678:
2679: END IF;
2680: