APPS.PO_DRAFTS_PVT dependencies on FND_GLOBAL

Line 2171: l_cur_conc_request_id NUMBER := FND_GLOBAL.conc_request_id;

2167: d_api_name CONSTANT VARCHAR2(30) := 'update_draft_status';
2168: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
2169: d_position NUMBER;
2170:
2171: l_cur_conc_request_id NUMBER := FND_GLOBAL.conc_request_id;
2172: BEGIN
2173:
2174: d_position := 0;
2175: IF (PO_LOG.d_proc) THEN

Line 7897: lck_tbl.last_updated_by = fnd_global.user_id,

7893: UPDATE
7894: SET
7895: lck_tbl.lock_type = lck_dat.lock_type,
7896: lck_tbl.last_update_date = SYSDATE,
7897: lck_tbl.last_updated_by = fnd_global.user_id,
7898: lck_tbl.last_update_login = fnd_global.login_id
7899: WHEN NOT MATCHED THEN
7900: INSERT(
7901: lck_tbl.po_entity_lock_id,

Line 7898: lck_tbl.last_update_login = fnd_global.login_id

7894: SET
7895: lck_tbl.lock_type = lck_dat.lock_type,
7896: lck_tbl.last_update_date = SYSDATE,
7897: lck_tbl.last_updated_by = fnd_global.user_id,
7898: lck_tbl.last_update_login = fnd_global.login_id
7899: WHEN NOT MATCHED THEN
7900: INSERT(
7901: lck_tbl.po_entity_lock_id,
7902: lck_tbl.entity_name,

Line 7924: fnd_global.user_id,

7920: lck_dat.entity_pk4,
7921: lck_dat.lock_by_draft_id,
7922: lck_dat.lock_type,
7923: SYSDATE,
7924: fnd_global.user_id,
7925: fnd_global.login_id,
7926: SYSDATE,
7927: fnd_global.user_id);
7928:

Line 7925: fnd_global.login_id,

7921: lck_dat.lock_by_draft_id,
7922: lck_dat.lock_type,
7923: SYSDATE,
7924: fnd_global.user_id,
7925: fnd_global.login_id,
7926: SYSDATE,
7927: fnd_global.user_id);
7928:
7929: d_position:=10;

Line 7927: fnd_global.user_id);

7923: SYSDATE,
7924: fnd_global.user_id,
7925: fnd_global.login_id,
7926: SYSDATE,
7927: fnd_global.user_id);
7928:
7929: d_position:=10;
7930: IF (PO_LOG.d_stmt) THEN
7931: PO_LOG.stmt(d_module, d_position,'Number Of rows Merged',SQL%ROWCOUNT);

Line 9111: fnd_global.user_id,

9107: p_lock_entity_pk4,
9108: p_lock_by_draft_id,
9109: p_lock_type ,
9110: SYSDATE,
9111: fnd_global.user_id,
9112: fnd_global.login_id,
9113: SYSDATE,
9114: fnd_global.user_id
9115: );

Line 9112: fnd_global.login_id,

9108: p_lock_by_draft_id,
9109: p_lock_type ,
9110: SYSDATE,
9111: fnd_global.user_id,
9112: fnd_global.login_id,
9113: SYSDATE,
9114: fnd_global.user_id
9115: );
9116:

Line 9114: fnd_global.user_id

9110: SYSDATE,
9111: fnd_global.user_id,
9112: fnd_global.login_id,
9113: SYSDATE,
9114: fnd_global.user_id
9115: );
9116:
9117: IF (PO_LOG.d_proc) THEN
9118: PO_LOG.proc_end(d_module, 'number of rows updated', SQL%ROWCOUNT);

Line 9236: fnd_global.user_id,

9232: po_draft_id_tbl(idx),
9233: 'NEW',--ChangeStatus
9234: Nvl(p_revision_num,0),
9235: SYSDATE,
9236: fnd_global.user_id,
9237: SYSDATE,
9238: fnd_global.user_id,
9239: fnd_global.login_id
9240: FROM

Line 9238: fnd_global.user_id,

9234: Nvl(p_revision_num,0),
9235: SYSDATE,
9236: fnd_global.user_id,
9237: SYSDATE,
9238: fnd_global.user_id,
9239: fnd_global.login_id
9240: FROM
9241: dual
9242: ) ;

Line 9239: fnd_global.login_id

9235: SYSDATE,
9236: fnd_global.user_id,
9237: SYSDATE,
9238: fnd_global.user_id,
9239: fnd_global.login_id
9240: FROM
9241: dual
9242: ) ;
9243:

Line 9311: fnd_global.user_id,

9307: po_draft_id_tbl(idx),
9308: 'Y',-- Delete Flag
9309: Nvl(p_revision_num,0),
9310: SYSDATE,
9311: fnd_global.user_id,
9312: SYSDATE,
9313: fnd_global.user_id,
9314: fnd_global.login_id
9315: FROM dual

Line 9313: fnd_global.user_id,

9309: Nvl(p_revision_num,0),
9310: SYSDATE,
9311: fnd_global.user_id,
9312: SYSDATE,
9313: fnd_global.user_id,
9314: fnd_global.login_id
9315: FROM dual
9316: WHERE NOT EXISTS (SELECT 1 FROM po_exhibit_details_draft exd
9317: WHERE exd.po_exhibit_details_id = po_exhibit_details_id_tbl(idx)

Line 9314: fnd_global.login_id

9310: SYSDATE,
9311: fnd_global.user_id,
9312: SYSDATE,
9313: fnd_global.user_id,
9314: fnd_global.login_id
9315: FROM dual
9316: WHERE NOT EXISTS (SELECT 1 FROM po_exhibit_details_draft exd
9317: WHERE exd.po_exhibit_details_id = po_exhibit_details_id_tbl(idx)
9318: )