APPS.PO_R12_CAT_UPG_PVT dependencies on PO_SESSION_GT

Line 3257: l_key PO_SESSION_GT.key%TYPE;

3253: l_api_name CONSTANT VARCHAR2(30) := 'get_hdr_process_code_list';
3254: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
3255: l_progress VARCHAR2(3) := '000';
3256:
3257: l_key PO_SESSION_GT.key%TYPE;
3258: i NUMBER;
3259: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3260: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3261: l_process_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;

Line 3274: SELECT PO_SESSION_GT_S.nextval

3270: RETURN;
3271: END IF;
3272:
3273: -- pick a new key from temp table which will be used in all validate logic
3274: SELECT PO_SESSION_GT_S.nextval
3275: INTO l_key
3276: FROM DUAL;
3277:
3278: l_progress := '020';

Line 3284: INSERT INTO PO_SESSION_GT(key,

3280:
3281: -- Check if the header had any errors. If yes, we need to skip the insert of the line
3282: l_progress := '030';
3283: FORALL i IN 1 .. p_doc_lines_rec.interface_line_id.COUNT
3284: INSERT INTO PO_SESSION_GT(key,
3285: num1,
3286: char1)
3287: SELECT l_key,
3288: l_subscript_array(i),

Line 3299: DELETE FROM PO_SESSION_GT

3295: l_progress := '040';
3296: -- SQL What: Transfer from session GT table to local arrays
3297: -- SQL Why : It will be used to get the process_codes
3298: -- SQL Join: key
3299: DELETE FROM PO_SESSION_GT
3300: WHERE key = l_key
3301: RETURNING num1, char1
3302: BULK COLLECT INTO l_indexes, l_process_code_list;
3303:

Line 3369: l_key PO_SESSION_GT.key%TYPE;

3365: l_max_po_line_num PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3366:
3367: l_valid_lines record_of_lines_type;
3368: l_count NUMBER;
3369: l_key PO_SESSION_GT.key%TYPE;
3370: i NUMBER;
3371: l_process_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
3372: BEGIN
3373: l_progress := '010';