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_LINES

Line 115: p_user_id IN po_lines.last_updated_by%TYPE,

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,
119: x_msg_data OUT NOCOPY VARCHAR2)

Line 116: p_login_id IN po_lines.last_update_login%TYPE ,

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,
119: x_msg_data OUT NOCOPY VARCHAR2)
120: IS

Line 201: po_lines pol ,

197: gt.num1,
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

Line 274: p_user_id IN po_lines.last_updated_by%TYPE,

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,
278: x_msg_data OUT NOCOPY VARCHAR2)

Line 275: p_login_id IN po_lines.last_update_login%TYPE ,

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,
278: x_msg_data OUT NOCOPY VARCHAR2)
279: IS

Line 366: po_lines pol,

362: 'DOC_NUM',gt.char6),
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

Line 440: p_user_id IN po_lines.last_updated_by%TYPE,

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,
444: x_msg_data OUT NOCOPY VARCHAR2)

Line 441: p_login_id IN po_lines.last_update_login%TYPE ,

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,
444: x_msg_data OUT NOCOPY VARCHAR2)
445: IS

Line 535: FROM po_lines pol1

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
536: WHERE pol1.po_line_id=pol.po_line_id
537: AND gt.char3=po_document_cancel_pvt.c_entity_level_LINE
538: UNION ALL
539: SELECT pol1.po_header_id

Line 540: FROM po_lines pol1

536: WHERE pol1.po_line_id=pol.po_line_id
537: AND gt.char3=po_document_cancel_pvt.c_entity_level_LINE
538: UNION ALL
539: SELECT pol1.po_header_id
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

Line 549: FROM po_lines pol1

545: WHERE
546: gt.KEY=p_key
547: AND gt.num1 IN
548: (SELECT pol1.po_line_id
549: FROM po_lines pol1
550: WHERE pol1.po_line_id=pol.po_line_id
551: AND gt.char3=po_document_cancel_pvt.c_entity_level_LINE
552: UNION ALL
553: SELECT pol1.po_header_id

Line 554: FROM po_lines pol1

550: WHERE pol1.po_line_id=pol.po_line_id
551: AND gt.char3=po_document_cancel_pvt.c_entity_level_LINE
552: UNION ALL
553: SELECT pol1.po_header_id
554: FROM po_lines pol1
555: WHERE pol1.po_line_id=pol.po_line_id
556: AND gt.char3=po_document_cancel_pvt.c_entity_level_HEADER))
557:
558: FROM

Line 559: po_lines pol

555: WHERE pol1.po_line_id=pol.po_line_id
556: AND gt.char3=po_document_cancel_pvt.c_entity_level_HEADER))
557:
558: FROM
559: po_lines pol
560: WHERE
561: pol.po_line_id IN
562: (SELECT DISTINCT po_line_id
563: FROM po_line_locations,

Line 642: p_user_id IN po_lines.last_updated_by%TYPE,

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,
646: x_msg_data OUT NOCOPY VARCHAR2)

Line 643: p_login_id IN po_lines.last_update_login%TYPE ,

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,
646: x_msg_data OUT NOCOPY VARCHAR2)
647: IS

Line 731: po_lines pol ,

727: gt.num1,
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.

Line 803: p_user_id IN po_lines.last_updated_by%TYPE,

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,
807: x_msg_data OUT NOCOPY VARCHAR2)

Line 804: p_login_id IN po_lines.last_update_login%TYPE ,

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,
807: x_msg_data OUT NOCOPY VARCHAR2)
808: IS

Line 911: po_lines pol ,

907: gt.num1,
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.

Line 992: p_user_id IN po_lines.last_updated_by%TYPE,

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,
996: x_msg_data OUT NOCOPY VARCHAR2)

Line 993: p_login_id IN po_lines.last_update_login%TYPE ,

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,
996: x_msg_data OUT NOCOPY VARCHAR2)
997: IS

Line 1087: po_lines pol ,

1083: gt.num1,
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 .

Line 1160: p_user_id IN po_lines.last_updated_by%TYPE,

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,
1164: x_msg_data OUT NOCOPY VARCHAR2)

Line 1161: p_login_id IN po_lines.last_update_login%TYPE ,

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,
1164: x_msg_data OUT NOCOPY VARCHAR2)
1165: IS

Line 1256: po_lines pol ,

1252: gt.char3
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 .

Line 1332: p_user_id IN po_lines.last_updated_by%TYPE,

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,
1336: x_msg_data OUT NOCOPY VARCHAR2)

Line 1333: p_login_id IN po_lines.last_update_login%TYPE ,

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,
1336: x_msg_data OUT NOCOPY VARCHAR2)
1337:

Line 1431: po_lines pol,

1427: gt.char3
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

Line 1510: p_user_id IN po_lines.last_updated_by%TYPE,

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,
1514: x_msg_data OUT NOCOPY VARCHAR2)

Line 1511: p_login_id IN po_lines.last_update_login%TYPE ,

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,
1514: x_msg_data OUT NOCOPY VARCHAR2)
1515:

Line 1618: po_lines pol,

1614: gt.char3
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

Line 1717: p_user_id IN po_lines.last_updated_by%TYPE,

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,
1721: x_msg_data OUT NOCOPY VARCHAR2)

Line 1718: p_login_id IN po_lines.last_update_login%TYPE ,

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,
1721: x_msg_data OUT NOCOPY VARCHAR2)
1722:

Line 1816: po_lines pol,

1812: gt.num1,
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

Line 1912: p_user_id IN po_lines.last_updated_by%TYPE,

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,
1916: x_msg_data OUT NOCOPY VARCHAR2)

Line 1913: p_login_id IN po_lines.last_update_login%TYPE ,

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,
1916: x_msg_data OUT NOCOPY VARCHAR2)
1917:

Line 2008: po_lines pol,

2004: gt.char3
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

Line 2107: p_user_id IN po_lines.last_updated_by%TYPE,

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,
2111: x_msg_data OUT NOCOPY VARCHAR2)

Line 2108: p_login_id IN po_lines.last_update_login%TYPE ,

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,
2111: x_msg_data OUT NOCOPY VARCHAR2)
2112:

Line 2211: po_lines pol,

2207: gt.num1,
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

Line 2291: p_user_id IN po_lines.last_updated_by%TYPE,

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,
2295: x_msg_data OUT NOCOPY VARCHAR2)

Line 2292: p_login_id IN po_lines.last_update_login%TYPE ,

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,
2295: x_msg_data OUT NOCOPY VARCHAR2)
2296:

Line 2372: po_lines pol,

2368: gt.num1,
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

Line 2447: p_user_id IN po_lines.last_updated_by%TYPE,

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,
2451: x_msg_data OUT NOCOPY VARCHAR2)

Line 2448: p_login_id IN po_lines.last_update_login%TYPE ,

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,
2451: x_msg_data OUT NOCOPY VARCHAR2)
2452:

Line 2528: po_lines pol,

2524: gt.num1,
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

Line 2607: p_user_id IN po_lines.last_updated_by%TYPE,

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,
2611: x_msg_data OUT NOCOPY VARCHAR2)

Line 2608: p_login_id IN po_lines.last_update_login%TYPE ,

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,
2611: x_msg_data OUT NOCOPY VARCHAR2)
2612:

Line 2695: po_lines pol,

2691: gt.char3
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

Line 2776: p_user_id IN po_lines.last_updated_by%TYPE,

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,
2780: x_msg_data OUT NOCOPY VARCHAR2)

Line 2777: p_login_id IN po_lines.last_update_login%TYPE ,

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,
2780: x_msg_data OUT NOCOPY VARCHAR2)
2781:

Line 2864: po_lines pol,

2860: gt.char3
2861: FROM
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

Line 2941: p_user_id IN po_lines.last_updated_by%TYPE,

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,
2945: x_msg_data OUT NOCOPY VARCHAR2)

Line 2942: p_login_id IN po_lines.last_update_login%TYPE ,

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,
2945: x_msg_data OUT NOCOPY VARCHAR2)
2946:

Line 3021: po_lines pol,

3017:
3018: gt.num1,
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

Line 3030: (SELECT 'Uncancelled std PO lines ref this ga line Exist'

3026: AND pol.po_line_id =gt.index_num1
3027: AND gt.char1 = po_document_cancel_pvt.c_doc_type_PA
3028: AND poh.global_agreement_flag = 'Y'
3029: AND EXISTS
3030: (SELECT 'Uncancelled std PO lines ref this ga line Exist'
3031: FROM po_lines POL1
3032: WHERE POL1.from_line_id = POL.po_line_id
3033: AND nvl(POL1.cancel_flag,'N') = 'N'
3034: AND nvl(POL1.closed_code, 'OPEN') <> 'FINALLY CLOSED'));

Line 3031: FROM po_lines POL1

3027: AND gt.char1 = po_document_cancel_pvt.c_doc_type_PA
3028: AND poh.global_agreement_flag = 'Y'
3029: AND EXISTS
3030: (SELECT 'Uncancelled std PO lines ref this ga line Exist'
3031: FROM po_lines POL1
3032: WHERE POL1.from_line_id = POL.po_line_id
3033: AND nvl(POL1.cancel_flag,'N') = 'N'
3034: AND nvl(POL1.closed_code, 'OPEN') <> 'FINALLY CLOSED'));
3035:

Line 3098: p_user_id IN po_lines.last_updated_by%TYPE,

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,
3102: x_msg_data OUT NOCOPY VARCHAR2)

Line 3099: p_login_id IN po_lines.last_update_login%TYPE ,

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,
3102: x_msg_data OUT NOCOPY VARCHAR2)
3103:

Line 3178: FROM po_lines pol,

3174: , 'DOC_NUM',gt.char6),
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

Line 3236: po_lines pol,

3232:
3233: gt.num1,
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

Line 3321: p_user_id IN po_lines.last_updated_by%TYPE,

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,
3325: x_msg_data OUT NOCOPY VARCHAR2)

Line 3322: p_login_id IN po_lines.last_update_login%TYPE ,

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,
3325: x_msg_data OUT NOCOPY VARCHAR2)
3326: IS

Line 3400: (SELECT 'Has open std Po lines ref this contract'

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'
3401: FROM po_lines POL
3402: WHERE POL.contract_id = gt.index_num1
3403: AND NVL(POL.cancel_flag, 'N') = 'N'
3404: AND NVL(POL.closed_code, 'OPEN') <> 'FINALLY CLOSED') );

Line 3401: FROM po_lines POL

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'
3401: FROM po_lines POL
3402: WHERE POL.contract_id = gt.index_num1
3403: AND NVL(POL.cancel_flag, 'N') = 'N'
3404: AND NVL(POL.closed_code, 'OPEN') <> 'FINALLY CLOSED') );
3405:

Line 3465: p_user_id IN po_lines.last_updated_by%TYPE,

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,
3469: x_msg_data OUT NOCOPY VARCHAR2)

Line 3466: p_login_id IN po_lines.last_update_login%TYPE ,

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,
3469: x_msg_data OUT NOCOPY VARCHAR2)
3470: IS

Line 3704: po_lines pol,

3700: WHERE po_header_id=pol.po_header_id
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'

Line 3805: p_login_id IN po_lines.last_update_login%TYPE,

3801: PROCEDURE validate_set(
3802: p_validation_set IN PO_TBL_VARCHAR2000,
3803: p_online_report_id IN NUMBER,
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,

Line 3806: p_user_id IN po_lines.last_updated_by%TYPE,

3802: p_validation_set IN PO_TBL_VARCHAR2000,
3803: p_online_report_id IN NUMBER,
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)

Line 4204: p_login_id IN po_lines.last_update_login%TYPE,

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,
4208: x_return_status OUT NOCOPY VARCHAR2,

Line 4205: p_user_id IN po_lines.last_updated_by%TYPE,

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,
4208: x_return_status OUT NOCOPY VARCHAR2,
4209: x_return_msg OUT NOCOPY VARCHAR2)

Line 4420: p_user_id IN po_lines.last_updated_by%TYPE,

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,
4424: x_return_status OUT NOCOPY VARCHAR2,

Line 4421: p_login_id IN po_lines.last_update_login%TYPE,

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,
4424: x_return_status OUT NOCOPY VARCHAR2,
4425: x_return_msg OUT NOCOPY VARCHAR2)

Line 4622: p_user_id IN po_lines.last_updated_by%TYPE,

4618: PROCEDURE val_doc_state_check(
4619: p_entity_rec_tbl IN po_document_action_pvt.entity_dtl_rec_type_tbl,
4620: p_online_report_id IN NUMBER,
4621: p_agent_id IN PO_HEADERS.agent_id%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,

Line 4623: p_login_id IN po_lines.last_update_login%TYPE,

4619: p_entity_rec_tbl IN po_document_action_pvt.entity_dtl_rec_type_tbl,
4620: p_online_report_id IN NUMBER,
4621: p_agent_id IN PO_HEADERS.agent_id%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,

Line 4900: -- Po Lines : Amount,Quantity and Unit Price

4896: -- If the user i/p flag "Revert_change_flag" is set to Y.
4897: -- Following columns are reverted :
4898: -- Po Distributions : Amount Ordered and Quantity Ordered
4899: -- Po Shipments : Amount,Quantity,Price Override,Need By date and Promised Date
4900: -- Po Lines : Amount,Quantity and Unit Price
4901:
4902:
4903: --Parameters:
4904: --IN:

Line 4928: p_user_id IN po_lines.last_updated_by%TYPE,

4924: p_api_version IN NUMBER,
4925: p_init_msg_list IN VARCHAR2,
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)

Line 4929: p_login_id IN po_lines.last_update_login%TYPE,

4925: p_init_msg_list IN VARCHAR2,
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

Line 5063: UPDATE po_lines pol

5059: FROM TABLE (CAST (l_line_loc_id_tbl AS po_tbl_number)));
5060:
5061:
5062: -- Reverting back the Lines Quantity and amount
5063: UPDATE po_lines pol
5064: SET (amount , quantity )=
5065: (SELECT SUM(DECODE(
5066: POLL.amount,
5067: NULL,

Line 5083: -- Bug 14580278 :Updating Price for Non Complex SPO Lines

5079: WHERE poll.po_line_id = pol.po_line_id)
5080: WHERE po_line_id IN (SELECT *
5081: FROM TABLE (CAST (l_line_id_tbl AS po_tbl_number)));
5082:
5083: -- Bug 14580278 :Updating Price for Non Complex SPO Lines
5084:
5085: UPDATE po_lines pol
5086: SET pol.unit_price =
5087: (SELECT unit_price

Line 5085: UPDATE po_lines pol

5081: FROM TABLE (CAST (l_line_id_tbl AS po_tbl_number)));
5082:
5083: -- Bug 14580278 :Updating Price for Non Complex SPO Lines
5084:
5085: UPDATE po_lines pol
5086: SET pol.unit_price =
5087: (SELECT unit_price
5088: FROM po_lines_archive_all
5089: WHERE po_line_id = pol.po_line_id

Line 5088: FROM po_lines_archive_all

5084:
5085: UPDATE po_lines pol
5086: SET pol.unit_price =
5087: (SELECT unit_price
5088: FROM po_lines_archive_all
5089: WHERE po_line_id = pol.po_line_id
5090: AND latest_external_flag='Y')
5091: WHERE po_line_id IN (SELECT po_line_id
5092: FROM po_line_locations poll

Line 5102: UPDATE po_lines pol

5098:
5099:
5100:
5101: -- Updating Price for Complex PO Line with Milestone pay items
5102: UPDATE po_lines pol
5103: SET pol.unit_price =
5104: (SELECT SUM(price_override)
5105: FROM po_line_locations
5106: WHERE po_line_id = pol.po_line_id)

Line 5194: po_lines pol,

5190: gt.num1,
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

Line 5283: p_user_id IN po_lines.last_updated_by%TYPE,

5279: --------------------------------------------------------------------------------
5280: PROCEDURE check_revert_pending_changes(
5281: p_revert_chg_flag IN VARCHAR2,
5282: p_online_report_id IN NUMBER,
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,

Line 5284: p_login_id IN po_lines.last_update_login%TYPE,

5280: PROCEDURE check_revert_pending_changes(
5281: p_revert_chg_flag IN VARCHAR2,
5282: p_online_report_id IN NUMBER,
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,

Line 5360: po_lines pol ,

5356: gt.char3
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

Line 5487: po_lines pol ,

5483: gt.char3
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

Line 5587: p_user_id IN po_lines.last_updated_by%TYPE,

5583:
5584: PROCEDURE check_cancel_reqs_flag(
5585: x_return_status OUT NOCOPY VARCHAR2,
5586: x_msg_data OUT NOCOPY VARCHAR2,
5587: p_user_id IN po_lines.last_updated_by%TYPE,
5588: p_login_id IN po_lines.last_update_login%TYPE,
5589: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
5590: x_cancel_reqs_flag IN OUT NOCOPY VARCHAR2,
5591: p_online_report_id IN NUMBER,

Line 5588: p_login_id IN po_lines.last_update_login%TYPE,

5584: PROCEDURE check_cancel_reqs_flag(
5585: x_return_status OUT NOCOPY VARCHAR2,
5586: x_msg_data OUT NOCOPY VARCHAR2,
5587: p_user_id IN po_lines.last_updated_by%TYPE,
5588: p_login_id IN po_lines.last_update_login%TYPE,
5589: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
5590: x_cancel_reqs_flag IN OUT NOCOPY VARCHAR2,
5591: p_online_report_id IN NUMBER,
5592: p_doc_type IN VARCHAR2,

Line 5746: -- valid po_line_id in po_lines

5742: -- should be a valid id at that level.
5743: -- - If the entity level is SHIPMENT, then the entity_id should a
5744: -- valid line_location_id in po_line_locations
5745: -- - If the entity level is LINE, then the entity_id should a
5746: -- valid po_line_id in po_lines
5747: -- - If the entity level is HEADER, then the entity_id should a
5748: -- valid po_header_id/po_release_id in po_headers/po_releases
5749: -- 2. Validate the parameter doc_id
5750: -- - doc_id should always be po_header_id

Line 5784: p_user_id IN po_lines.last_updated_by%TYPE,

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,
5788: x_return_msg OUT NOCOPY VARCHAR2)

Line 5785: p_login_id IN po_lines.last_update_login%TYPE,

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,
5788: x_return_msg OUT NOCOPY VARCHAR2)
5789: IS

Line 5917: -- then the entity_id should a valid po_line_id in po_lines

5913: p_sequence := P_SEQUENCE + SQL%ROWCOUNT;
5914: l_progress := '003';
5915:
5916: -- Validate : If the entity level is LINE,
5917: -- then the entity_id should a valid po_line_id in po_lines
5918: INSERT INTO PO_ONLINE_REPORT_TEXT(
5919: ONLINE_REPORT_ID,
5920: LAST_UPDATE_LOGIN,
5921: LAST_UPDATED_BY,

Line 5954: FROM po_lines pol

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
5955: WHERE pol.po_line_id = gt.num1
5956: ));
5957:
5958:

Line 6114: FROM po_lines pol,

6110: org_organization_definitions ood
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

Line 6204: -- po_line_id in po_lines

6200: -- should be a valid id at that level.
6201: -- - If the entity level is SHIPMENT, then the entity_id should a
6202: -- valid line_location_id in po_line_locations
6203: -- - If the entity level is LINE, then the entity_id should a valid
6204: -- po_line_id in po_lines
6205: -- - If the entity level is HEADER, then the entity_id should a
6206: -- valid po_header_id/po_release_id in po_headers/po_releases
6207: -- 2. Validate the parameter doc_id
6208: -- - doc_id should always be po_header_id

Line 6249: p_user_id IN po_lines.last_updated_by%TYPE,

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,
6253: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

Line 6250: p_login_id IN po_lines.last_update_login%TYPE,

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,
6253: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
6254: x_return_status OUT NOCOPY VARCHAR2,

Line 6712: p_user_id IN po_lines.last_updated_by%TYPE,

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,
6716: x_return_status OUT NOCOPY VARCHAR2,

Line 6713: p_login_id IN po_lines.last_update_login%TYPE,

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,
6716: x_return_status OUT NOCOPY VARCHAR2,
6717: x_msg_data OUT NOCOPY VARCHAR2,