APPS.PO_DIFF_SUMMARY_PKG dependencies on PO_SESSION_GT

Line 3317: l_key PO_SESSION_GT.key%TYPE;

3313: d_api_name CONSTANT VARCHAR2(30) := 'validate_disposition';
3314: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
3315: d_position NUMBER;
3316:
3317: l_key PO_SESSION_GT.key%TYPE;
3318:
3319: BEGIN
3320:
3321: d_position := 0;

Line 3345: INSERT INTO po_session_gt

3341:
3342: d_position := 10;
3343:
3344: FORALL i IN 1..p_reject_line_id_list.COUNT
3345: INSERT INTO po_session_gt
3346: ( key,
3347: index_num1, -- po_line_id
3348: num2, -- line_num
3349: char2 -- delete_flag

Line 3368: FROM po_session_gt PSG

3364: num2
3365: BULK COLLECT
3366: INTO x_invalid_line_id_list,
3367: x_invalid_line_num_list
3368: FROM po_session_gt PSG
3369: WHERE PSG.key = l_key
3370: AND PSG.char2 = 'Y' -- delete_flag
3371: AND EXISTS
3372: (SELECT NULL

Line 3379: FROM po_session_gt PSG1

3375: AND NVL(PLD.delete_flag, 'N') <> 'Y'
3376: AND PLD.line_num = PSG.num2 -- line_num
3377: AND NOT EXISTS
3378: (SELECT NULL
3379: FROM po_session_gt PSG1
3380: WHERE PSG1.key = l_key
3381: AND PSG1.index_num1 = PLD.po_line_id));
3382:
3383: d_position := 30;

Line 3385: DELETE FROM po_session_gt

3381: AND PSG1.index_num1 = PLD.po_line_id));
3382:
3383: d_position := 30;
3384:
3385: DELETE FROM po_session_gt
3386: WHERE key = l_key;
3387:
3388: IF (x_invalid_line_id_list.COUNT > 0) THEN
3389: x_return_status := FND_API.G_RET_STS_ERROR;