APPS.PO_COPYDOC_SUB dependencies on PO_SESSION_GT

Line 3125: -- PO_SESSION_GT

3121: --Pre-reqs:
3122: -- None.
3123: --Modifies:
3124: -- PO_ONLINE_REPORT_TEXT
3125: -- PO_SESSION_GT
3126: -- PO_SESSION_GT_S
3127: --Locks:
3128: -- None.
3129: --Function:

Line 3126: -- PO_SESSION_GT_S

3122: -- None.
3123: --Modifies:
3124: -- PO_ONLINE_REPORT_TEXT
3125: -- PO_SESSION_GT
3126: -- PO_SESSION_GT_S
3127: --Locks:
3128: -- None.
3129: --Function:
3130: -- Validates all the enabled org assignments of the Global Agreement

Line 3165: l_key PO_SESSION_GT.key%TYPE;

3161: l_login_id NUMBER;
3162: l_err_prefix VARCHAR2(256);
3163: l_populate_failed_exc EXCEPTION;
3164:
3165: l_key PO_SESSION_GT.key%TYPE;
3166: l_text_line PO_ONLINE_REPORT_TEXT.text_line%TYPE;
3167: l_message_type PO_ONLINE_REPORT_TEXT.message_type%TYPE;
3168:
3169: BEGIN

Line 3224: FROM po_session_gt psg

3220: SYSDATE,
3221: x_sequence + ROWNUM,
3222: SUBSTRB(l_err_prefix||psg.char1||l_text_line,1,2000),
3223: l_message_type
3224: FROM po_session_gt psg
3225: WHERE psg.key = l_key
3226: AND NOT EXISTS
3227: (SELECT 'is active ou'
3228: FROM hr_operating_units hou,

Line 3272: FROM po_session_gt psg

3268: SYSDATE,
3269: x_sequence + ROWNUM,
3270: SUBSTRB(l_err_prefix||psg.char1||l_text_line,1,2000),
3271: l_message_type
3272: FROM po_session_gt psg
3273: WHERE psg.key = l_key
3274: AND (NOT EXISTS
3275: (SELECT 'is active ou'
3276: FROM hr_operating_units hou,

Line 3348: FROM po_session_gt psg

3344: SYSDATE,
3345: x_sequence + ROWNUM,
3346: SUBSTRB(l_err_prefix||psg.char1||l_text_line,1,2000),
3347: l_message_type
3348: FROM po_session_gt psg
3349: WHERE psg.key = l_key
3350: AND NOT EXISTS
3351: (SELECT 'Valid vendor site'
3352: FROM po_vendor_sites_all pvsa

Line 3386: -- PO_SESSION_GT

3382: --Name: populate_session_gt
3383: --Pre-reqs:
3384: -- None.
3385: --Modifies:
3386: -- PO_SESSION_GT
3387: -- PO_SESSION_GT_S
3388: --Locks:
3389: -- None.
3390: --Function:

Line 3387: -- PO_SESSION_GT_S

3383: --Pre-reqs:
3384: -- None.
3385: --Modifies:
3386: -- PO_SESSION_GT
3387: -- PO_SESSION_GT_S
3388: --Locks:
3389: -- None.
3390: --Function:
3391: -- Populates the global session table PO_SESSION_GT with all the org

Line 3391: -- Populates the global session table PO_SESSION_GT with all the org

3387: -- PO_SESSION_GT_S
3388: --Locks:
3389: -- None.
3390: --Function:
3391: -- Populates the global session table PO_SESSION_GT with all the org
3392: -- assignments of p_po_header_id that are enabled. The columns populated are:
3393: -- key -> x_key
3394: -- num1 -> Requesting Org ID
3395: -- num2 -> Purchasing Org ID

Line 3413: -- The next value in the PO_SESSION_GT_S sequence to be used as the key for

3409: --x_return_status
3410: -- FND_API.g_ret_sts_success - success
3411: -- FND_API.g_ret_sts_unexp_error - unexpected error occurs
3412: --x_key
3413: -- The next value in the PO_SESSION_GT_S sequence to be used as the key for
3414: -- all the data inserted.
3415: --End of Comments
3416: --------------------------------------------------------------------------------
3417: PROCEDURE populate_session_gt

Line 3435: SELECT po_session_gt_s.nextval

3431: l_progress := '000';
3432: x_return_status := FND_API.g_ret_sts_success;
3433:
3434: -- Get the key for the global session table to use for this GA
3435: SELECT po_session_gt_s.nextval
3436: INTO x_key
3437: FROM DUAL;
3438:
3439: l_progress := '010';

Line 3443: INSERT INTO po_session_gt

3439: l_progress := '010';
3440:
3441: -- Populate the global session table with all enabled org assignments for
3442: -- the current GA.
3443: INSERT INTO po_session_gt
3444: (
3445: key,
3446: num1,
3447: num2,