DBA Data[Home] [Help]

APPS.PO_EXHIBITS_PVT dependencies on FND_GLOBAL

Line 1078: fnd_global.user_id,

1074: p_exhibit_description_tbl(i),
1075: p_is_cdrl_tbl(i),
1076: p_revision_num_tbl(i),
1077: SYSDATE ,
1078: fnd_global.user_id,
1079: SYSDATE,
1080: fnd_global.user_id,
1081: fnd_global.login_id
1082: FROM dual

Line 1080: fnd_global.user_id,

1076: p_revision_num_tbl(i),
1077: SYSDATE ,
1078: fnd_global.user_id,
1079: SYSDATE,
1080: fnd_global.user_id,
1081: fnd_global.login_id
1082: FROM dual
1083: WHERE NOT EXISTS (SELECT 1 FROM po_exhibit_details ex
1084: WHERE ex.exhibit_name = p_exhibit_name_tbl(i)

Line 1081: fnd_global.login_id

1077: SYSDATE ,
1078: fnd_global.user_id,
1079: SYSDATE,
1080: fnd_global.user_id,
1081: fnd_global.login_id
1082: FROM dual
1083: WHERE NOT EXISTS (SELECT 1 FROM po_exhibit_details ex
1084: WHERE ex.exhibit_name = p_exhibit_name_tbl(i)
1085: AND ex.po_header_id = p_document_id_tbl(i));

Line 1137: fnd_global.user_id,

1133: p_is_cdrl_tbl(i),
1134: 'NEW',
1135: p_revision_num_tbl(i),
1136: SYSDATE ,
1137: fnd_global.user_id,
1138: SYSDATE,
1139: fnd_global.user_id,
1140: fnd_global.login_id
1141: FROM po_drafts dft

Line 1139: fnd_global.user_id,

1135: p_revision_num_tbl(i),
1136: SYSDATE ,
1137: fnd_global.user_id,
1138: SYSDATE,
1139: fnd_global.user_id,
1140: fnd_global.login_id
1141: FROM po_drafts dft
1142: WHERE dft.draft_id = p_document_id_tbl(i)
1143: AND NOT EXISTS (SELECT 1 FROM po_exhibit_details_merge_v mex

Line 1140: fnd_global.login_id

1136: SYSDATE ,
1137: fnd_global.user_id,
1138: SYSDATE,
1139: fnd_global.user_id,
1140: fnd_global.login_id
1141: FROM po_drafts dft
1142: WHERE dft.draft_id = p_document_id_tbl(i)
1143: AND NOT EXISTS (SELECT 1 FROM po_exhibit_details_merge_v mex
1144: WHERE mex.exhibit_name = p_exhibit_name_tbl(i)

Line 1362: fnd_global.user_id,

1358: exhibit_description,
1359: is_cdrl,
1360: revision_num,
1361: SYSDATE ,
1362: fnd_global.user_id,
1363: SYSDATE,
1364: fnd_global.user_id,
1365: fnd_global.login_id
1366: FROM po_exhibit_details

Line 1364: fnd_global.user_id,

1360: revision_num,
1361: SYSDATE ,
1362: fnd_global.user_id,
1363: SYSDATE,
1364: fnd_global.user_id,
1365: fnd_global.login_id
1366: FROM po_exhibit_details
1367: WHERE po_header_id = p_po_header_id
1368: AND exhibit_name = p_exhibit_name;

Line 1365: fnd_global.login_id

1361: SYSDATE ,
1362: fnd_global.user_id,
1363: SYSDATE,
1364: fnd_global.user_id,
1365: fnd_global.login_id
1366: FROM po_exhibit_details
1367: WHERE po_header_id = p_po_header_id
1368: AND exhibit_name = p_exhibit_name;
1369:

Line 1408: fnd_global.user_id,

1404: is_cdrl,
1405: 'NEW',
1406: revision_num,
1407: SYSDATE ,
1408: fnd_global.user_id,
1409: SYSDATE,
1410: fnd_global.user_id,
1411: fnd_global.login_id
1412: FROM po_exhibit_details_draft dft

Line 1410: fnd_global.user_id,

1406: revision_num,
1407: SYSDATE ,
1408: fnd_global.user_id,
1409: SYSDATE,
1410: fnd_global.user_id,
1411: fnd_global.login_id
1412: FROM po_exhibit_details_draft dft
1413: WHERE po_header_id = p_po_header_id
1414: AND draft_id = p_po_draft_id

Line 1411: fnd_global.login_id

1407: SYSDATE ,
1408: fnd_global.user_id,
1409: SYSDATE,
1410: fnd_global.user_id,
1411: fnd_global.login_id
1412: FROM po_exhibit_details_draft dft
1413: WHERE po_header_id = p_po_header_id
1414: AND draft_id = p_po_draft_id
1415: AND exhibit_name = p_exhibit_name;