APPS.PO_DIFF_SUMMARY_PKG dependencies on PO_SESSION_GT

Line 3343: l_key PO_SESSION_GT.key%TYPE;

3339: d_api_name CONSTANT VARCHAR2(30) := 'validate_disposition';
3340: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
3341: d_position NUMBER;
3342:
3343: l_key PO_SESSION_GT.key%TYPE;
3344:
3345: BEGIN
3346:
3347: d_position := 0;

Line 3371: INSERT INTO po_session_gt

3367:
3368: d_position := 10;
3369:
3370: FORALL i IN 1..p_reject_line_id_list.COUNT
3371: INSERT INTO po_session_gt
3372: ( key,
3373: index_num1, -- po_line_id
3374: num2, -- line_num
3375: char2 -- delete_flag

Line 3394: FROM po_session_gt PSG

3390: num2
3391: BULK COLLECT
3392: INTO x_invalid_line_id_list,
3393: x_invalid_line_num_list
3394: FROM po_session_gt PSG
3395: WHERE PSG.key = l_key
3396: AND PSG.char2 = 'Y' -- delete_flag
3397: AND EXISTS
3398: (SELECT NULL

Line 3405: FROM po_session_gt PSG1

3401: AND NVL(PLD.delete_flag, 'N') <> 'Y'
3402: AND PLD.line_num = PSG.num2 -- line_num
3403: AND NOT EXISTS
3404: (SELECT NULL
3405: FROM po_session_gt PSG1
3406: WHERE PSG1.key = l_key
3407: AND PSG1.index_num1 = PLD.po_line_id));
3408:
3409: d_position := 30;

Line 3411: DELETE FROM po_session_gt

3407: AND PSG1.index_num1 = PLD.po_line_id));
3408:
3409: d_position := 30;
3410:
3411: DELETE FROM po_session_gt
3412: WHERE key = l_key;
3413:
3414: IF (x_invalid_line_id_list.COUNT > 0) THEN
3415: x_return_status := FND_API.G_RET_STS_ERROR;