APPS.PO_COPYDOC_SUB dependencies on PO_SESSION_GT

Line 2931: -- PO_SESSION_GT

2927: --Pre-reqs:
2928: -- None.
2929: --Modifies:
2930: -- PO_ONLINE_REPORT_TEXT
2931: -- PO_SESSION_GT
2932: -- PO_SESSION_GT_S
2933: --Locks:
2934: -- None.
2935: --Function:

Line 2932: -- PO_SESSION_GT_S

2928: -- None.
2929: --Modifies:
2930: -- PO_ONLINE_REPORT_TEXT
2931: -- PO_SESSION_GT
2932: -- PO_SESSION_GT_S
2933: --Locks:
2934: -- None.
2935: --Function:
2936: -- Validates all the enabled org assignments of the Global Agreement

Line 2971: l_key PO_SESSION_GT.key%TYPE;

2967: l_login_id NUMBER;
2968: l_err_prefix VARCHAR2(256);
2969: l_populate_failed_exc EXCEPTION;
2970:
2971: l_key PO_SESSION_GT.key%TYPE;
2972: l_text_line PO_ONLINE_REPORT_TEXT.text_line%TYPE;
2973: l_message_type PO_ONLINE_REPORT_TEXT.message_type%TYPE;
2974:
2975: BEGIN

Line 3030: FROM po_session_gt psg

3026: SYSDATE,
3027: x_sequence + ROWNUM,
3028: SUBSTRB(l_err_prefix||psg.char1||l_text_line,1,2000),
3029: l_message_type
3030: FROM po_session_gt psg
3031: WHERE psg.key = l_key
3032: AND NOT EXISTS
3033: (SELECT 'is active ou'
3034: FROM hr_operating_units hou,

Line 3078: FROM po_session_gt psg

3074: SYSDATE,
3075: x_sequence + ROWNUM,
3076: SUBSTRB(l_err_prefix||psg.char1||l_text_line,1,2000),
3077: l_message_type
3078: FROM po_session_gt psg
3079: WHERE psg.key = l_key
3080: AND (NOT EXISTS
3081: (SELECT 'is active ou'
3082: FROM hr_operating_units hou,

Line 3154: FROM po_session_gt psg

3150: SYSDATE,
3151: x_sequence + ROWNUM,
3152: SUBSTRB(l_err_prefix||psg.char1||l_text_line,1,2000),
3153: l_message_type
3154: FROM po_session_gt psg
3155: WHERE psg.key = l_key
3156: AND NOT EXISTS
3157: (SELECT 'Valid vendor site'
3158: FROM po_vendor_sites_all pvsa

Line 3192: -- PO_SESSION_GT

3188: --Name: populate_session_gt
3189: --Pre-reqs:
3190: -- None.
3191: --Modifies:
3192: -- PO_SESSION_GT
3193: -- PO_SESSION_GT_S
3194: --Locks:
3195: -- None.
3196: --Function:

Line 3193: -- PO_SESSION_GT_S

3189: --Pre-reqs:
3190: -- None.
3191: --Modifies:
3192: -- PO_SESSION_GT
3193: -- PO_SESSION_GT_S
3194: --Locks:
3195: -- None.
3196: --Function:
3197: -- Populates the global session table PO_SESSION_GT with all the org

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

3193: -- PO_SESSION_GT_S
3194: --Locks:
3195: -- None.
3196: --Function:
3197: -- Populates the global session table PO_SESSION_GT with all the org
3198: -- assignments of p_po_header_id that are enabled. The columns populated are:
3199: -- key -> x_key
3200: -- num1 -> Requesting Org ID
3201: -- num2 -> Purchasing Org ID

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

3215: --x_return_status
3216: -- FND_API.g_ret_sts_success - success
3217: -- FND_API.g_ret_sts_unexp_error - unexpected error occurs
3218: --x_key
3219: -- The next value in the PO_SESSION_GT_S sequence to be used as the key for
3220: -- all the data inserted.
3221: --End of Comments
3222: --------------------------------------------------------------------------------
3223: PROCEDURE populate_session_gt

Line 3241: SELECT po_session_gt_s.nextval

3237: l_progress := '000';
3238: x_return_status := FND_API.g_ret_sts_success;
3239:
3240: -- Get the key for the global session table to use for this GA
3241: SELECT po_session_gt_s.nextval
3242: INTO x_key
3243: FROM DUAL;
3244:
3245: l_progress := '010';

Line 3249: INSERT INTO po_session_gt

3245: l_progress := '010';
3246:
3247: -- Populate the global session table with all enabled org assignments for
3248: -- the current GA.
3249: INSERT INTO po_session_gt
3250: (
3251: key,
3252: num1,
3253: num2,