eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_CONTROL_ACTION_VALIDATIONS dependencies on PO_SESSION_GT

Line 114: p_key IN po_session_gt.key%TYPE,

110: --End of Comments
111: --------------------------------------------------------------------------------
112: PROCEDURE qty_rec_grt_ord_chk(
113: p_online_report_id IN NUMBER,
114: p_key IN po_session_gt.key%TYPE,
115: p_user_id IN po_lines.last_updated_by%TYPE,
116: p_login_id IN po_lines.last_update_login%TYPE ,
117: p_sequence IN OUT NOCOPY NUMBER,
118: x_return_status OUT NOCOPY VARCHAR2,

Line 202: po_session_gt gt

198: gt.char3
199: FROM
200: po_line_locations poll,
201: po_lines pol ,
202: po_session_gt gt
203: WHERE gt.key=p_key
204: AND poll.line_location_id = gt.index_num1 -- lowestentityid i.e.
205: AND poll.po_line_id = pol.po_line_id
206: AND gt.char1 <> po_document_cancel_pvt.c_doc_type_PA

Line 273: p_key IN po_session_gt.key%TYPE,

269: -- End of Comments
270: --------------------------------------------------------------------------------
271: PROCEDURE line_price_chk(
272: p_online_report_id IN NUMBER,
273: p_key IN po_session_gt.key%TYPE,
274: p_user_id IN po_lines.last_updated_by%TYPE,
275: p_login_id IN po_lines.last_update_login%TYPE ,
276: p_sequence IN OUT NOCOPY NUMBER,
277: x_return_status OUT NOCOPY VARCHAR2,

Line 367: po_session_gt gt

363: gt.num1,
364: gt.char3
365: FROM
366: po_lines pol,
367: po_session_gt gt
368: WHERE
369: gt.key = p_key
370: AND gt.char1 = po_document_cancel_pvt.c_doc_type_PA
371: AND gt.char2 <>po_document_cancel_pvt.c_doc_subtype_contract

Line 439: p_key IN po_session_gt.key%TYPE,

435: --End of Comments
436: --------------------------------------------------------------------------------
437: PROCEDURE line_ship_qty_chk(
438: p_online_report_id IN NUMBER,
439: p_key IN po_session_gt.key%TYPE,
440: p_user_id IN po_lines.last_updated_by%TYPE,
441: p_login_id IN po_lines.last_update_login%TYPE ,
442: p_sequence IN OUT NOCOPY NUMBER,
443: x_return_status OUT NOCOPY VARCHAR2,

Line 531: FROM po_session_gt gt

527: FROM po_line_locations poll
528: WHERE poll.po_line_id = pol.po_line_id )),
529: 'DOC_NUM',(SELECT segment1 FROM po_headers WHERE po_header_id=pol.po_header_id)),
530: (SELECT gt.num1
531: FROM po_session_gt gt
532: WHERE gt.KEY=p_key
533: AND gt.num1 IN
534: (SELECT pol1.po_line_id
535: FROM po_lines pol1

Line 544: FROM po_session_gt gt

540: FROM po_lines pol1
541: WHERE pol1.po_line_id=pol.po_line_id
542: AND gt.char3=po_document_cancel_pvt.c_entity_level_HEADER)),
543: (SELECT gt.char3
544: FROM po_session_gt gt
545: WHERE
546: gt.KEY=p_key
547: AND gt.num1 IN
548: (SELECT pol1.po_line_id

Line 564: po_session_gt gt

560: WHERE
561: pol.po_line_id IN
562: (SELECT DISTINCT po_line_id
563: FROM po_line_locations,
564: po_session_gt gt
565: WHERE gt.KEY=p_key
566: AND line_location_id= gt.index_num1 -- lowestentityid)
567: AND gt.char1 = po_document_cancel_pvt.c_doc_type_PO
568: AND gt.char3<> po_document_cancel_pvt.c_entity_level_SHIPMENT)

Line 641: p_key IN po_session_gt.key%TYPE,

637: --------------------------------------------------------------------------------
638:
639: PROCEDURE line_ship_price_chk(
640: p_online_report_id IN NUMBER,
641: p_key IN po_session_gt.key%TYPE,
642: p_user_id IN po_lines.last_updated_by%TYPE,
643: p_login_id IN po_lines.last_update_login%TYPE ,
644: p_sequence IN OUT NOCOPY NUMBER,
645: x_return_status OUT NOCOPY VARCHAR2,

Line 732: po_session_gt gt

728: gt.char3
729: FROM
730: po_line_locations poll,
731: po_lines pol ,
732: po_session_gt gt
733: WHERE
734: gt.key=p_key
735: AND poll.line_location_id = gt.index_num1 -- lowestentityid i.e.
736: AND poll.po_line_id = pol.po_line_id

Line 802: p_key IN po_session_gt.key%TYPE,

798: --------------------------------------------------------------------------------
799:
800: PROCEDURE ship_dist_qty_chk(
801: p_online_report_id IN NUMBER,
802: p_key IN po_session_gt.key%TYPE,
803: p_user_id IN po_lines.last_updated_by%TYPE,
804: p_login_id IN po_lines.last_update_login%TYPE ,
805: p_sequence IN OUT NOCOPY NUMBER,
806: x_return_status OUT NOCOPY VARCHAR2,

Line 912: po_session_gt gt

908: gt.char3
909: FROM
910: po_line_locations poll,
911: po_lines pol ,
912: po_session_gt gt
913: WHERE
914: gt.key=p_key
915: AND poll.line_location_id = gt.index_num1 -- lowestentityid i.e.
916: AND poll.po_line_id = pol.po_line_id

Line 991: p_key IN po_session_gt.key%TYPE,

987: --------------------------------------------------------------------------------
988:
989: PROCEDURE lcm_match_option_chk(
990: p_online_report_id IN NUMBER,
991: p_key IN po_session_gt.key%TYPE,
992: p_user_id IN po_lines.last_updated_by%TYPE,
993: p_login_id IN po_lines.last_update_login%TYPE ,
994: p_sequence IN OUT NOCOPY NUMBER,
995: x_return_status OUT NOCOPY VARCHAR2,

Line 1088: po_session_gt gt

1084: gt.char3
1085: FROM
1086: po_line_locations poll,
1087: po_lines pol ,
1088: po_session_gt gt
1089: WHERE
1090: gt.key=p_key
1091: AND poll.line_location_id = gt.index_num1 -- i.e lowestentityid .
1092: AND poll.po_line_id = pol.po_line_id

Line 1159: p_key IN po_session_gt.key%TYPE,

1155: --------------------------------------------------------------------------------
1156:
1157: PROCEDURE lcm_dest_type_chk(
1158: p_online_report_id IN NUMBER,
1159: p_key IN po_session_gt.key%TYPE,
1160: p_user_id IN po_lines.last_updated_by%TYPE,
1161: p_login_id IN po_lines.last_update_login%TYPE ,
1162: p_sequence IN OUT NOCOPY NUMBER,
1163: x_return_status OUT NOCOPY VARCHAR2,

Line 1257: po_session_gt gt

1253: FROM
1254: po_distributions_all pod,
1255: po_line_locations poll,
1256: po_lines pol ,
1257: po_session_gt gt
1258: WHERE
1259: gt.key=p_key
1260: AND poll.line_location_id = gt.index_num1 -- i.e lowestentityid .
1261: AND poll.po_line_id = pol.po_line_id

Line 1331: p_key IN po_session_gt.key%TYPE,

1327: --------------------------------------------------------------------------------
1328:
1329: PROCEDURE qty_del_grt_ord_chk(
1330: p_online_report_id IN NUMBER,
1331: p_key IN po_session_gt.key%TYPE,
1332: p_user_id IN po_lines.last_updated_by%TYPE,
1333: p_login_id IN po_lines.last_update_login%TYPE ,
1334: p_sequence IN OUT NOCOPY NUMBER,
1335: x_return_status OUT NOCOPY VARCHAR2,

Line 1432: po_session_gt gt

1428: FROM
1429: po_distributions pod,
1430: po_line_locations poll,
1431: po_lines pol,
1432: po_session_gt gt
1433: WHERE
1434: gt.key=p_key
1435: AND pod.line_location_id = gt.index_num1
1436: AND pod.line_location_id = poll.line_location_id

Line 1509: p_key IN po_session_gt.key%TYPE,

1505: --------------------------------------------------------------------------------
1506:
1507: PROCEDURE qty_bill_grt_ord_chk(
1508: p_online_report_id IN NUMBER,
1509: p_key IN po_session_gt.key%TYPE,
1510: p_user_id IN po_lines.last_updated_by%TYPE,
1511: p_login_id IN po_lines.last_update_login%TYPE ,
1512: p_sequence IN OUT NOCOPY NUMBER,
1513: x_return_status OUT NOCOPY VARCHAR2,

Line 1619: po_session_gt gt

1615: FROM
1616: po_distributions pod,
1617: po_line_locations poll,
1618: po_lines pol,
1619: po_session_gt gt
1620: WHERE
1621: gt.key=p_key
1622: AND pod.line_location_id = gt.index_num1
1623: AND pod.line_location_id = poll.line_location_id

Line 1716: p_key IN po_session_gt.key%TYPE,

1712: --------------------------------------------------------------------------------
1713:
1714: PROCEDURE qty_bill_grt_rec_chk(
1715: p_online_report_id IN NUMBER,
1716: p_key IN po_session_gt.key%TYPE,
1717: p_user_id IN po_lines.last_updated_by%TYPE,
1718: p_login_id IN po_lines.last_update_login%TYPE ,
1719: p_sequence IN OUT NOCOPY NUMBER,
1720: x_return_status OUT NOCOPY VARCHAR2,

Line 1817: po_session_gt gt

1813: gt.char3
1814: FROM
1815: po_line_locations poll,
1816: po_lines pol,
1817: po_session_gt gt
1818: WHERE gt.key=p_key
1819: AND poll.line_location_id = gt.index_num1
1820: AND pol.po_line_id = poll.po_line_id
1821: AND nvl(POLL.receipt_required_flag, 'Y')<> 'N'

Line 1911: p_key IN po_session_gt.key%TYPE,

1907: --------------------------------------------------------------------------------
1908:
1909: PROCEDURE qty_bill_grt_del_chk(
1910: p_online_report_id IN NUMBER,
1911: p_key IN po_session_gt.key%TYPE,
1912: p_user_id IN po_lines.last_updated_by%TYPE,
1913: p_login_id IN po_lines.last_update_login%TYPE ,
1914: p_sequence IN OUT NOCOPY NUMBER,
1915: x_return_status OUT NOCOPY VARCHAR2,

Line 2009: po_session_gt gt

2005: FROM
2006: po_distributions pod,
2007: po_line_locations poll,
2008: po_lines pol,
2009: po_session_gt gt
2010: WHERE
2011: gt.key=p_key
2012: AND pod.line_location_id = gt.index_num1
2013: AND pod.line_location_id = poll.line_location_id

Line 2106: p_key IN po_session_gt.key%TYPE,

2102: --------------------------------------------------------------------------------
2103:
2104: PROCEDURE qty_rec_not_del_chk(
2105: p_online_report_id IN NUMBER,
2106: p_key IN po_session_gt.key%TYPE,
2107: p_user_id IN po_lines.last_updated_by%TYPE,
2108: p_login_id IN po_lines.last_update_login%TYPE ,
2109: p_sequence IN OUT NOCOPY NUMBER,
2110: x_return_status OUT NOCOPY VARCHAR2,

Line 2212: po_session_gt gt

2208: gt.char3
2209: FROM
2210: po_line_locations poll,
2211: po_lines pol,
2212: po_session_gt gt
2213:
2214: WHERE gt.KEY =p_key
2215: AND poll.line_location_id =gt.index_num1
2216: AND pol.po_line_id = poll.po_line_id

Line 2290: p_key IN po_session_gt.key%TYPE,

2286: --------------------------------------------------------------------------------
2287:
2288: PROCEDURE pending_rcv_trx_chk(
2289: p_online_report_id IN NUMBER,
2290: p_key IN po_session_gt.key%TYPE,
2291: p_user_id IN po_lines.last_updated_by%TYPE,
2292: p_login_id IN po_lines.last_update_login%TYPE ,
2293: p_sequence IN OUT NOCOPY NUMBER,
2294: x_return_status OUT NOCOPY VARCHAR2,

Line 2373: po_session_gt gt

2369: gt.char3
2370: FROM
2371: po_line_locations poll,
2372: po_lines pol,
2373: po_session_gt gt
2374: WHERE
2375: gt.key=p_key
2376: AND poll.line_location_id =gt.index_num1
2377: AND pol.po_line_id = poll.po_line_id

Line 2446: p_key IN po_session_gt.key%TYPE,

2442: --------------------------------------------------------------------------------
2443:
2444: PROCEDURE pending_asn_chk(
2445: p_online_report_id IN NUMBER,
2446: p_key IN po_session_gt.key%TYPE,
2447: p_user_id IN po_lines.last_updated_by%TYPE,
2448: p_login_id IN po_lines.last_update_login%TYPE ,
2449: p_sequence IN OUT NOCOPY NUMBER,
2450: x_return_status OUT NOCOPY VARCHAR2,

Line 2529: po_session_gt gt

2525: gt.char3
2526: FROM
2527: po_line_locations poll,
2528: po_lines pol,
2529: po_session_gt gt
2530: WHERE gt.key=p_key
2531: AND poll.line_location_id =gt.index_num1
2532: AND pol.po_line_id = poll.po_line_id
2533: AND gt.char1 <> po_document_cancel_pvt.c_doc_type_PA

Line 2606: p_key IN po_session_gt.key%TYPE,

2602:
2603: PROCEDURE invalid_budget_acct_chk(
2604: p_online_report_id IN NUMBER,
2605: p_action_date IN DATE,
2606: p_key IN po_session_gt.key%TYPE,
2607: p_user_id IN po_lines.last_updated_by%TYPE,
2608: p_login_id IN po_lines.last_update_login%TYPE ,
2609: p_sequence IN OUT NOCOPY NUMBER,
2610: x_return_status OUT NOCOPY VARCHAR2,

Line 2696: po_session_gt gt,

2692: FROM
2693: po_distributions pod,
2694: po_line_locations poll,
2695: po_lines pol,
2696: po_session_gt gt,
2697: FINANCIALS_SYSTEM_PARAMETERS FSP,
2698: gl_code_combinations gcc
2699: WHERE gt.key=p_key
2700: AND pod.line_location_id=gt.index_num1

Line 2775: p_key IN po_session_gt.key%TYPE,

2771:
2772: PROCEDURE invalid_charge_acct_chk(
2773: p_online_report_id IN NUMBER,
2774: p_action_date IN DATE,
2775: p_key IN po_session_gt.key%TYPE,
2776: p_user_id IN po_lines.last_updated_by%TYPE,
2777: p_login_id IN po_lines.last_update_login%TYPE ,
2778: p_sequence IN OUT NOCOPY NUMBER,
2779: x_return_status OUT NOCOPY VARCHAR2,

Line 2866: po_session_gt gt

2862: po_distributions pod,
2863: po_line_locations poll,
2864: po_lines pol,
2865: gl_code_combinations gcc,
2866: po_session_gt gt
2867: WHERE gt.key=p_key
2868: AND pod.line_location_id=gt.index_num1
2869: AND POD.line_location_id = POLL.line_location_id
2870: AND POL.po_line_id = POLL.po_line_id

Line 2940: p_key IN po_session_gt.key%TYPE,

2936: --------------------------------------------------------------------------------
2937:
2938: PROCEDURE ga_with_open_std_ref_chk(
2939: p_online_report_id IN NUMBER,
2940: p_key IN po_session_gt.key%TYPE,
2941: p_user_id IN po_lines.last_updated_by%TYPE,
2942: p_login_id IN po_lines.last_update_login%TYPE ,
2943: p_sequence IN OUT NOCOPY NUMBER,
2944: x_return_status OUT NOCOPY VARCHAR2,

Line 3023: po_session_gt gt

3019: gt.char3
3020: FROM
3021: po_lines pol,
3022: po_headers poh,
3023: po_session_gt gt
3024: WHERE gt.key=p_key
3025: AND poh.po_header_id=pol.po_header_id
3026: AND pol.po_line_id =gt.index_num1
3027: AND gt.char1 = po_document_cancel_pvt.c_doc_type_PA

Line 3097: p_key IN po_session_gt.key%TYPE,

3093: --------------------------------------------------------------------------------
3094:
3095: PROCEDURE po_pa_WITH_OPEN_REL_chk(
3096: p_online_report_id IN NUMBER,
3097: p_key IN po_session_gt.key%TYPE,
3098: p_user_id IN po_lines.last_updated_by%TYPE,
3099: p_login_id IN po_lines.last_update_login%TYPE ,
3100: p_sequence IN OUT NOCOPY NUMBER,
3101: x_return_status OUT NOCOPY VARCHAR2,

Line 3179: po_session_gt gt

3175:
3176: gt.num1,
3177: gt.char3
3178: FROM po_lines pol,
3179: po_session_gt gt
3180: WHERE gt.key=p_key
3181: AND pol.po_line_id =gt.index_num1
3182: -- bug 16174863
3183: AND gt.char1 = po_document_cancel_pvt.c_doc_type_PA

Line 3238: po_session_gt gt

3234: gt.char3
3235: FROM
3236: po_lines pol,
3237: po_line_locations poll,
3238: po_session_gt gt
3239: WHERE gt.key=p_key
3240: AND poll.LINE_LOCATION_ID =gt.index_num1
3241: AND pol.po_line_id =poll.po_line_id
3242: AND gt.char2 = po_document_cancel_pvt.c_doc_subtype_PLANNED

Line 3320: p_key IN po_session_gt.key%TYPE,

3316: --------------------------------------------------------------------------------
3317:
3318: PROCEDURE cga_with_open_std_ref_chk(
3319: p_online_report_id IN NUMBER,
3320: p_key IN po_session_gt.key%TYPE,
3321: p_user_id IN po_lines.last_updated_by%TYPE,
3322: p_login_id IN po_lines.last_update_login%TYPE ,
3323: p_sequence IN OUT NOCOPY NUMBER,
3324: x_return_status OUT NOCOPY VARCHAR2,

Line 3396: po_session_gt gt

3392:
3393: gt.num1,
3394: gt.char3
3395: FROM
3396: po_session_gt gt
3397: WHERE gt.key=p_key
3398: AND gt.char1 = po_document_cancel_pvt.c_doc_type_PA
3399: AND EXISTS
3400: (SELECT 'Has open std Po lines ref this contract'

Line 3464: p_key IN po_session_gt.key%TYPE,

3460: --------------------------------------------------------------------------------
3461:
3462: PROCEDURE cancel_custom_validation(
3463: p_online_report_id IN NUMBER,
3464: p_key IN po_session_gt.key%TYPE,
3465: p_user_id IN po_lines.last_updated_by%TYPE,
3466: p_login_id IN po_lines.last_update_login%TYPE ,
3467: p_sequence IN OUT NOCOPY NUMBER,
3468: x_return_status OUT NOCOPY VARCHAR2,

Line 3523: --Modifies: p_key to a new key in po_session_gt [see the explanation below]

3519: --------------------------------------------------------------------------------
3520: --Start of Comments
3521: --Name:
3522: --
3523: --Modifies: p_key to a new key in po_session_gt [see the explanation below]
3524: -- Function:
3525: -- Cancel action be performed at any of the three levels[Header/Line/Shipment]
3526: -- for a docuemnt
3527: -- But All Business Rules Valdiations are with the :

Line 3537: -- the entity being cancelled based on the entity_level and updating in po_session_gt.

3533: -- are validated, For BPA header, its lines are used for validation, so on.
3534: -- So in order to avoid multiple if else conditions like,If entity level=Header,
3535: -- then join with po_header_id, else for entity_level=LINE
3536: -- then join with po_line_id, and so on,fetching all the lowest entities for
3537: -- the entity being cancelled based on the entity_level and updating in po_session_gt.
3538: --
3539: -- The entire entity record was already inserted in po_session_gt with l_old_key,
3540: -- but as the lowest entity for a document can be multiple,
3541: -- ex: there can be more than one shipment for a PO, so not updating the

Line 3539: -- The entire entity record was already inserted in po_session_gt with l_old_key,

3535: -- then join with po_header_id, else for entity_level=LINE
3536: -- then join with po_line_id, and so on,fetching all the lowest entities for
3537: -- the entity being cancelled based on the entity_level and updating in po_session_gt.
3538: --
3539: -- The entire entity record was already inserted in po_session_gt with l_old_key,
3540: -- but as the lowest entity for a document can be multiple,
3541: -- ex: there can be more than one shipment for a PO, so not updating the
3542: -- existing records in po_session_gt,
3543: -- rather inserting new records[with key=l_new_key],which will be used further

Line 3542: -- existing records in po_session_gt,

3538: --
3539: -- The entire entity record was already inserted in po_session_gt with l_old_key,
3540: -- but as the lowest entity for a document can be multiple,
3541: -- ex: there can be more than one shipment for a PO, so not updating the
3542: -- existing records in po_session_gt,
3543: -- rather inserting new records[with key=l_new_key],which will be used further
3544: -- for validations.
3545: -- Following is the entity record and columns in po_session_gt mapping:
3546: -- entity_id - num1

Line 3545: -- Following is the entity record and columns in po_session_gt mapping:

3541: -- ex: there can be more than one shipment for a PO, so not updating the
3542: -- existing records in po_session_gt,
3543: -- rather inserting new records[with key=l_new_key],which will be used further
3544: -- for validations.
3545: -- Following is the entity record and columns in po_session_gt mapping:
3546: -- entity_id - num1
3547: -- document_type - char1
3548: -- document_subtype - char2
3549: -- entity_level - char3

Line 3576: p_key IN OUT NOCOPY po_session_gt.key%TYPE,

3572: --------------------------------------------------------------------------------
3573:
3574: PROCEDURE update_gt_with_low_entity(
3575: p_entity_rec_tbl IN po_document_action_pvt.entity_dtl_rec_type_tbl,
3576: p_key IN OUT NOCOPY po_session_gt.key%TYPE,
3577: x_return_status OUT NOCOPY VARCHAR2,
3578: x_msg_data OUT NOCOPY VARCHAR2)
3579: IS
3580:

Line 3585: l_old_key po_session_gt.key%TYPE;

3581: d_api_name CONSTANT VARCHAR2(30) := 'update_gt_with_low_entity.';
3582: d_module CONSTANT VARCHAR2(100) := g_pkg_name||d_api_name;
3583: l_progress VARCHAR2(3):= '000';
3584:
3585: l_old_key po_session_gt.key%TYPE;
3586: l_new_key po_session_gt.key%TYPE;
3587:
3588: BEGIN
3589:

Line 3586: l_new_key po_session_gt.key%TYPE;

3582: d_module CONSTANT VARCHAR2(100) := g_pkg_name||d_api_name;
3583: l_progress VARCHAR2(3):= '000';
3584:
3585: l_old_key po_session_gt.key%TYPE;
3586: l_new_key po_session_gt.key%TYPE;
3587:
3588: BEGIN
3589:
3590: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3616: INSERT INTO PO_session_gt gt(

3612:
3613: -- Lowest entity for SPO/PPO and Releases that will be used for validations
3614: -- is Shipments .Get all the shipments for the SPO/PPO and Releases for
3615: -- entity level =shipment/line/header
3616: INSERT INTO PO_session_gt gt(
3617: key,
3618: index_num1,
3619: num1,
3620: char1,

Line 3650: po_session_gt pgt

3646: WHERE po_header_id=poll.po_header_id)
3647: ),
3648: date1
3649: FROM po_line_locations poll,
3650: po_session_gt pgt
3651: WHERE pgt.key = l_old_key
3652: AND nvl(poll.cancel_flag,'N') = 'N'
3653: AND nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
3654: AND ( ( pgt.char3 = po_document_cancel_pvt.c_entity_level_shipment

Line 3678: INSERT INTO po_session_gt gt(

3674:
3675: -- Lowest entity for BPA /GBPA that will be used for validations is Lines
3676: -- Get all the Lines for the BPA /GBPA for entity level =line/header
3677:
3678: INSERT INTO po_session_gt gt(
3679: key,
3680: num1,
3681: index_num1,
3682: char1,

Line 3705: po_session_gt pgt

3701: ),
3702: date1
3703: FROM
3704: po_lines pol,
3705: po_session_gt pgt
3706: WHERE pgt.key = l_old_key
3707: AND nvl(pol.cancel_flag,'N') = 'N'
3708: AND nvl(pol.closed_code, 'OPEN') <> 'FINALLY CLOSED'
3709: AND (( pgt.char3 = po_document_cancel_pvt.c_entity_level_line

Line 3721: INSERT INTO po_session_gt gt(

3717:
3718: -- Lowest entity for CPA that will be used for validations is CPA Header
3719: -- Get all the Header id for the CPA for entity level =header
3720:
3721: INSERT INTO po_session_gt gt(
3722: key,
3723: num1,
3724: index_num1,
3725: char1,

Line 3746: FROM po_session_gt pgt

3742: FROM po_headers
3743: WHERE po_header_id=num1
3744: ),
3745: date1
3746: FROM po_session_gt pgt
3747: WHERE pgt.key = l_old_key
3748: AND pgt.char1 = po_document_cancel_pvt.c_doc_type_PA
3749: AND pgt.char2 = po_document_cancel_pvt.c_doc_subtype_contract);
3750:

Line 3808: p_key IN po_session_gt.key%TYPE,

3804: p_action_date IN DATE,
3805: p_login_id IN po_lines.last_update_login%TYPE,
3806: p_user_id IN po_lines.last_updated_by%TYPE,
3807: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
3808: p_key IN po_session_gt.key%TYPE,
3809: x_return_status OUT NOCOPY VARCHAR2,
3810: x_msg_data OUT NOCOPY VARCHAR2)
3811:
3812: IS

Line 4203: p_key IN po_session_gt.key%TYPE,

4199:
4200: PROCEDURE po_cancel_action_checks(
4201: p_entity_rec_tbl IN po_document_action_pvt.entity_dtl_rec_type_tbl,
4202: p_action_date IN DATE,
4203: p_key IN po_session_gt.key%TYPE,
4204: p_login_id IN po_lines.last_update_login%TYPE,
4205: p_user_id IN po_lines.last_updated_by%TYPE,
4206: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
4207: p_online_report_id IN NUMBER,

Line 4419: p_key IN po_session_gt.key%TYPE,

4415:
4416: PROCEDURE val_security_check(
4417: p_entity_rec_tbl IN po_document_action_pvt.entity_dtl_rec_type_tbl,
4418: p_online_report_id IN NUMBER,
4419: p_key IN po_session_gt.key%TYPE,
4420: p_user_id IN po_lines.last_updated_by%TYPE,
4421: p_login_id IN po_lines.last_update_login%TYPE,
4422: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
4423: p_agent_id IN PO_HEADERS.agent_id%TYPE,

Line 4485: po_session_gt gt

4481: 'DOC_NUM', gt.char6),
4482: gt.num1,
4483: gt.char3
4484: FROM po_headers poh,
4485: po_session_gt gt
4486: WHERE gt.key=p_key
4487: AND poh.po_header_id = gt.char4
4488: AND gt.char1 <> po_document_cancel_pvt.c_doc_type_RELEASE
4489: AND (po_control_action_validations.val_doc_security(

Line 4539: po_session_gt gt

4535: gt.num1,
4536: gt.char3
4537: FROM
4538: po_releases prh,
4539: po_session_gt gt
4540: WHERE gt.key=p_key
4541: AND prh.po_release_id = gt.char4
4542: AND gt.char1 = po_document_cancel_pvt.c_doc_type_RELEASE
4543: AND(po_control_action_validations.val_doc_security(

Line 4626: p_key IN po_session_gt.key%TYPE,

4622: p_user_id IN po_lines.last_updated_by%TYPE,
4623: p_login_id IN po_lines.last_update_login%TYPE,
4624: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
4625: p_source IN VARCHAR2 DEFAULT NULL,
4626: p_key IN po_session_gt.key%TYPE,
4627: x_return_status OUT NOCOPY VARCHAR2,
4628: x_return_msg OUT NOCOPY VARCHAR2)
4629: IS
4630:

Line 4930: p_key IN po_session_gt.key%TYPE,

4926: p_revert_chg_flag IN VARCHAR2,
4927: p_online_report_id IN NUMBER,
4928: p_user_id IN po_lines.last_updated_by%TYPE,
4929: p_login_id IN po_lines.last_update_login%TYPE,
4930: p_key IN po_session_gt.key%TYPE,
4931: x_return_status OUT NOCOPY VARCHAR2,
4932: x_msg_data OUT NOCOPY VARCHAR2)
4933: IS
4934:

Line 5006: FROM po_session_gt gt,

5002: WHERE poad.po_distribution_id =pod.po_distribution_id
5003: AND poad.latest_external_flag ='Y')
5004: WHERE pod.line_location_id IN
5005: (SELECT poll.line_location_id
5006: FROM po_session_gt gt,
5007: po_line_locations poll,
5008: po_line_locations_archive_all poall
5009: WHERE gt.key=p_key
5010: AND gt.char1 <> PO_Document_Cancel_PVT.c_doc_type_PA

Line 5195: po_session_gt gt

5191: gt.char3
5192: FROM
5193: po_line_locations poll,
5194: po_lines pol,
5195: po_session_gt gt
5196: WHERE
5197: gt.key=p_key
5198: AND gt.char1 <> PO_Document_Cancel_PVT.c_doc_type_PA
5199: AND poll.po_line_id = pol.po_line_id

Line 5287: p_low_level_key IN po_session_gt.key%TYPE,

5283: p_user_id IN po_lines.last_updated_by%TYPE,
5284: p_login_id IN po_lines.last_update_login%TYPE,
5285: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
5286: p_source IN VARCHAR2 DEFAULT NULL,
5287: p_low_level_key IN po_session_gt.key%TYPE,
5288: p_entity_level_key IN po_session_gt.key%TYPE,
5289: p_po_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE,
5290: x_return_status OUT NOCOPY VARCHAR2,
5291: x_return_msg OUT NOCOPY VARCHAR2)

Line 5288: p_entity_level_key IN po_session_gt.key%TYPE,

5284: p_login_id IN po_lines.last_update_login%TYPE,
5285: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
5286: p_source IN VARCHAR2 DEFAULT NULL,
5287: p_low_level_key IN po_session_gt.key%TYPE,
5288: p_entity_level_key IN po_session_gt.key%TYPE,
5289: p_po_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE,
5290: x_return_status OUT NOCOPY VARCHAR2,
5291: x_return_msg OUT NOCOPY VARCHAR2)
5292: IS

Line 5361: po_session_gt gt

5357: FROM
5358: po_distributions_all pod,
5359: po_line_locations poll,
5360: po_lines pol ,
5361: po_session_gt gt
5362: WHERE
5363: gt.key=p_low_level_key
5364: AND pod.line_location_id=poll.line_location_id
5365: AND poll.line_location_id = gt.index_num1 -- lowestentityid i.e.

Line 5488: po_session_gt gt

5484: FROM
5485: po_distributions_all pod,
5486: po_line_locations poll,
5487: po_lines pol ,
5488: po_session_gt gt
5489: WHERE
5490: gt.key=p_low_level_key
5491: AND pod.line_location_id=poll.line_location_id
5492: AND poll.line_location_id = gt.index_num1 -- lowestentityid i.e.

Line 5783: p_key IN po_session_gt.key%TYPE,

5779:
5780: PROCEDURE validate_doc_params(
5781: p_entity_rec_tbl IN po_document_action_pvt.entity_dtl_rec_type_tbl,
5782: p_online_report_id IN NUMBER,
5783: p_key IN po_session_gt.key%TYPE,
5784: p_user_id IN po_lines.last_updated_by%TYPE,
5785: p_login_id IN po_lines.last_update_login%TYPE,
5786: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
5787: x_return_status OUT NOCOPY VARCHAR2,

Line 5849: po_session_gt gt

5845: ),
5846: gt.num1,
5847: gt.char3
5848: FROM
5849: po_session_gt gt
5850: WHERE gt.key=p_key
5851: AND (gt.char1 IS NULL
5852: OR gt.char2 IS NULL
5853: OR gt.char1 NOT IN (po_document_cancel_pvt.c_doc_type_PO,

Line 5904: po_session_gt gt

5900: gt.num1),
5901: gt.num1,
5902: gt.char3
5903: FROM
5904: po_session_gt gt
5905: WHERE gt.key=p_key
5906: AND gt.char3 =po_document_cancel_pvt.c_entity_level_SHIPMENT
5907: AND NOT EXISTS (SELECT '1'
5908: FROM po_line_locations poll

Line 5950: po_session_gt gt

5946: gt.num1),
5947: gt.num1,
5948: gt.char3
5949: FROM
5950: po_session_gt gt
5951: WHERE gt.key=p_key
5952: AND gt.char3 =po_document_cancel_pvt.c_entity_level_LINE
5953: AND NOT EXISTS(SELECT '1'
5954: FROM po_lines pol

Line 5996: po_session_gt gt

5992: gt.num1),
5993: gt.num1,
5994: gt.char3
5995: FROM
5996: po_session_gt gt
5997: WHERE gt.key=p_key
5998: AND gt.char3 =po_document_cancel_pvt.c_entity_level_HEADER
5999: AND gt.char1<>po_document_cancel_pvt.c_doc_type_RELEASE
6000: AND NOT EXISTS (SELECT '1'

Line 6042: po_session_gt gt

6038: gt.num1),
6039: gt.num1,
6040: gt.char3
6041: FROM
6042: po_session_gt gt
6043: WHERE gt.key=p_key
6044: AND gt.char3 =po_document_cancel_pvt.c_entity_level_HEADER
6045: AND gt.char1 =po_document_cancel_pvt.c_doc_type_RELEASE
6046: AND NOT EXISTS (SELECT '1'

Line 6090: po_session_gt gt

6086: gt.char4),
6087: gt.num1,
6088: gt.char3
6089: FROM
6090: po_session_gt gt
6091: WHERE gt.key=p_key
6092: AND GT.char3 <> PO_Document_Cancel_PVT.c_entity_level_HEADER
6093: AND NOT EXISTS (SELECT '1'
6094: FROM po_headers poh

Line 6115: po_session_gt gt

6111: WHERE ood.organization_id=org_id
6112: AND po_header_id IN
6113: (SELECT pol.po_header_id
6114: FROM po_lines pol,
6115: po_session_gt gt
6116: WHERE gt.KEY=p_key
6117: AND gt.num1=pol.po_line_id
6118: AND gt.char3=PO_Document_Cancel_PVT.c_entity_level_LINE
6119: UNION ALL

Line 6122: po_session_gt gt

6118: AND gt.char3=PO_Document_Cancel_PVT.c_entity_level_LINE
6119: UNION ALL
6120: SELECT poll.po_header_id
6121: FROM po_line_locations poll,
6122: po_session_gt gt
6123: WHERE gt.KEY=p_key
6124: AND gt.num1=poll.line_location_id
6125: AND gt.char3=PO_Document_Cancel_PVT.c_entity_level_SHIPMENT
6126: UNION ALL

Line 6128: FROM po_session_gt gt

6124: AND gt.num1=poll.line_location_id
6125: AND gt.char3=PO_Document_Cancel_PVT.c_entity_level_SHIPMENT
6126: UNION ALL
6127: SELECT gt.num1
6128: FROM po_session_gt gt
6129: WHERE gt.KEY=p_key
6130: AND gt.char3=PO_Document_Cancel_PVT.c_entity_level_HEADER
6131: ) ;
6132:

Line 6248: p_key IN po_session_gt.key%TYPE,

6244:
6245: PROCEDURE validate_cancel_action_params(
6246: p_da_call_rec IN OUT NOCOPY po_document_action_pvt.DOC_ACTION_CALL_TBL_REC_TYPE,
6247: p_online_report_id IN NUMBER,
6248: p_key IN po_session_gt.key%TYPE,
6249: p_user_id IN po_lines.last_updated_by%TYPE,
6250: p_login_id IN po_lines.last_update_login%TYPE,
6251: p_po_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE,
6252: p_req_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE,

Line 6419: po_session_gt gt

6415: l_action_date),
6416: gt.num1,
6417: gt.char3
6418: FROM
6419: po_session_gt gt
6420: WHERE gt.key=p_key
6421: AND gt.char4 =l_entity_rec_tbl(i).doc_id
6422: );
6423:

Line 6434: UPDATE po_session_gt

6430: l_doc_id_tbl.extend;
6431: id_count:=id_count+1;
6432: l_doc_id_tbl(id_count):=l_entity_rec_tbl(i).doc_id;
6433:
6434: UPDATE po_session_gt
6435: SET date1= l_action_date
6436: WHERE KEY=p_key
6437: AND char4= l_entity_rec_tbl(i).doc_id;
6438:

Line 6531: p_key IN po_session_gt.key%TYPE,

6527: --End of Comments
6528: --------------------------------------------------------------------------------
6529:
6530: PROCEDURE mark_errored_record(
6531: p_key IN po_session_gt.key%TYPE,
6532: p_online_report_id IN NUMBER,
6533: p_entity_rec_tbl IN OUT NOCOPY po_document_action_pvt.entity_dtl_rec_type_tbl,
6534: x_return_status OUT NOCOPY VARCHAR2,
6535: x_return_msg OUT NOCOPY VARCHAR2,

Line 6564: -- table] in po_session_gt to 'N'

6560: x_return_code :='S';
6561:
6562:
6563: -- Upadate char5[column corresponding to process_entity_flag in entity record
6564: -- table] in po_session_gt to 'N'
6565: -- If there is an entry in po_online_report_text for the entity_id and
6566: -- entity_level combination
6567: -- Columns mapping :
6568: -- entity_id in entity record = num1 in session gt = transaction_id in

Line 6575: UPDATE po_session_gt

6571: -- po_online_report_text
6572: -- process_entity_flag in entity record char5 in session gt
6573:
6574:
6575: UPDATE po_session_gt
6576: SET char5 ='N'
6577: WHERE KEY=p_key
6578: AND EXISTS(SELECT 'error record exists'
6579: FROM po_online_report_text

Line 6589: PO_DEBUG.debug_var(d_module,l_progress,'records updated in po_session_gt',l_count);

6585:
6586: l_count :=SQL%ROWCOUNT;
6587:
6588: IF g_debug_stmt THEN
6589: PO_DEBUG.debug_var(d_module,l_progress,'records updated in po_session_gt',l_count);
6590: END IF;
6591:
6592: IF l_count>0 THEN
6593: x_return_code :='F';

Line 6601: -- Bulk select from po_session_gt back into entity record so that the

6597: END IF;
6598:
6599: l_progress := '002';
6600:
6601: -- Bulk select from po_session_gt back into entity record so that the
6602: -- corresponding process_entity_flag gets updated in entity record
6603: -- doc_id,document_type,document_subtype,entity_id,entity_level,
6604: -- process_entity_flag,recreate_demand_flag
6605:

Line 6617: po_session_gt

6613: 'N'
6614: BULK COLLECT INTO
6615: p_entity_rec_tbl
6616: FROM
6617: po_session_gt
6618: WHERE KEY=p_key
6619: ORDER BY char4;
6620:
6621: l_count :=SQL%ROWCOUNT;

Line 6711: p_key IN po_session_gt.key%TYPE,

6707: --------------------------------------------------------------------------------
6708:
6709: PROCEDURE validate_cancel_action(
6710: p_da_call_rec IN OUT NOCOPY po_document_action_pvt.DOC_ACTION_CALL_TBL_REC_TYPE,
6711: p_key IN po_session_gt.key%TYPE,
6712: p_user_id IN po_lines.last_updated_by%TYPE,
6713: p_login_id IN po_lines.last_update_login%TYPE,
6714: p_po_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE,
6715: p_req_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE,

Line 6722: l_temp_key po_session_gt.key%TYPE;

6718: x_return_code OUT NOCOPY VARCHAR2)
6719: IS
6720:
6721: l_online_report_id NUMBER;
6722: l_temp_key po_session_gt.key%TYPE;
6723: l_key po_session_gt.key%TYPE;
6724:
6725:
6726:

Line 6723: l_key po_session_gt.key%TYPE;

6719: IS
6720:
6721: l_online_report_id NUMBER;
6722: l_temp_key po_session_gt.key%TYPE;
6723: l_key po_session_gt.key%TYPE;
6724:
6725:
6726:
6727: l_agent_id PO_HEADERS.agent_id%TYPE := FND_GLOBAL.employee_id;

Line 6948: DELETE FROM po_session_gt WHERE KEY=l_temp_key;

6944: END IF;
6945:
6946: l_progress := '010';
6947:
6948: DELETE FROM po_session_gt WHERE KEY=l_temp_key;
6949:
6950: l_progress :='011';
6951:
6952: --Update the process_entity_flag to N in p_da_call_rec