APPS.PO_DOCUMENT_ACTIONS_SV dependencies on PO_SESSION_GT

Line 98: -- What we are trying to do is to insert these rows into the po_session_gt

94: l_id_key := PO_CORE_S.get_session_gt_nextval();
95: l_num_lines := p_req_header_id_tbl.COUNT;
96:
97:
98: -- What we are trying to do is to insert these rows into the po_session_gt
99: -- table and then do a bulk collect.
100: -- For 8i compatibility, need to do 2 bulk collects.
101: -- Need to have one to insert and then another one to update.
102: FORALL i in 1..l_num_lines

Line 103: INSERT INTO PO_SESSION_GT(key, num1)

99: -- table and then do a bulk collect.
100: -- For 8i compatibility, need to do 2 bulk collects.
101: -- Need to have one to insert and then another one to update.
102: FORALL i in 1..l_num_lines
103: INSERT INTO PO_SESSION_GT(key, num1)
104: VALUES (l_id_key, p_req_header_id_tbl(i))
105: RETURNING ROWIDTOCHAR(rowid)
106: BULK COLLECT INTO l_rowid_char_tbl
107: ;

Line 110: UPDATE PO_SESSION_GT SES

106: BULK COLLECT INTO l_rowid_char_tbl
107: ;
108:
109: FORALL i in 1..l_num_lines
110: UPDATE PO_SESSION_GT SES
111: SET
112: ( char1, -- document sub type
113: num2, -- approval id
114: num3 -- org_id