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_DOCUMENT_CHECKS_PVT dependencies on PO_TBL_NUMBER

Line 116: p_header_id IN PO_TBL_NUMBER,

112:
113: -- bug3592160 START
114: PROCEDURE complete_po_header_id_tbl
115: ( p_count IN NUMBER,
116: p_header_id IN PO_TBL_NUMBER,
117: p_release_id IN PO_TBL_NUMBER,
118: p_vendor_order_num IN PO_TBL_VARCHAR30,
119: p_document_num IN PO_TBL_VARCHAR30,
120: p_type_lookup_code IN PO_TBL_VARCHAR30,

Line 117: p_release_id IN PO_TBL_NUMBER,

113: -- bug3592160 START
114: PROCEDURE complete_po_header_id_tbl
115: ( p_count IN NUMBER,
116: p_header_id IN PO_TBL_NUMBER,
117: p_release_id IN PO_TBL_NUMBER,
118: p_vendor_order_num IN PO_TBL_VARCHAR30,
119: p_document_num IN PO_TBL_VARCHAR30,
120: p_type_lookup_code IN PO_TBL_VARCHAR30,
121: x_header_id OUT NOCOPY PO_TBL_NUMBER

Line 121: x_header_id OUT NOCOPY PO_TBL_NUMBER

117: p_release_id IN PO_TBL_NUMBER,
118: p_vendor_order_num IN PO_TBL_VARCHAR30,
119: p_document_num IN PO_TBL_VARCHAR30,
120: p_type_lookup_code IN PO_TBL_VARCHAR30,
121: x_header_id OUT NOCOPY PO_TBL_NUMBER
122: );
123: -- bug3592160 END
124:
125: --

Line 554: l_id_tbl po_tbl_number;

550: l_log_head CONSTANT VARCHAR2(100) := g_log_head||l_api_name;
551: l_progress VARCHAR2(3);
552:
553: l_document_id NUMBER;
554: l_id_tbl po_tbl_number;
555:
556: l_num_messages NUMBER := 0; -- bug3574165: Changed l_num_errors to l_num_messages
557: l_num_warnings NUMBER := 0; -- bug3574165
558:

Line 605: , p_doc_level_id_tbl => po_tbl_number( p_document_level_id )

601:
602: PO_CORE_S.get_document_ids(
603: p_doc_type => p_document_type
604: , p_doc_level => p_document_level
605: , p_doc_level_id_tbl => po_tbl_number( p_document_level_id )
606: , x_doc_id_tbl => l_id_tbl
607: );
608:
609: l_document_id := l_id_tbl(1);

Line 10117: l_id_tbl po_tbl_number;

10113: l_return_status VARCHAR2(1);
10114:
10115: l_doc_id NUMBER;
10116:
10117: l_id_tbl po_tbl_number;
10118:
10119: BEGIN
10120: l_progress := '000';
10121:

Line 10149: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )

10145:
10146: PO_CORE_S.get_document_ids(
10147: p_doc_type => p_doc_type
10148: , p_doc_level => p_doc_level
10149: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )
10150: , x_doc_id_tbl => l_id_tbl
10151: );
10152:
10153: l_progress := '510';

Line 11206: l_line_id_tbl po_tbl_number;

11202:
11203: l_api_name CONSTANT varchar2(40) := 'POPULATE_PO_LINES_GT';
11204: l_progress VARCHAR2(3);
11205:
11206: l_line_id_tbl po_tbl_number;
11207:
11208: BEGIN
11209:
11210: l_progress := '000';

Line 11224: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )

11220:
11221: PO_CORE_S.get_line_ids(
11222: p_doc_type => p_doc_type
11223: , p_doc_level => p_doc_level
11224: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )
11225: , x_line_id_tbl => l_line_id_tbl
11226: );
11227:
11228: l_progress := '020';

Line 12671: p_header_id IN PO_TBL_NUMBER,

12667: -------------------------------------------------------------------------------
12668:
12669: PROCEDURE check_updatable (
12670: p_count IN NUMBER,
12671: p_header_id IN PO_TBL_NUMBER,
12672: p_release_id IN PO_TBL_NUMBER,
12673: p_document_type IN PO_TBL_VARCHAR30,
12674: p_document_subtype IN PO_TBL_VARCHAR30,
12675: p_document_num IN PO_TBL_VARCHAR30,

Line 12672: p_release_id IN PO_TBL_NUMBER,

12668:
12669: PROCEDURE check_updatable (
12670: p_count IN NUMBER,
12671: p_header_id IN PO_TBL_NUMBER,
12672: p_release_id IN PO_TBL_NUMBER,
12673: p_document_type IN PO_TBL_VARCHAR30,
12674: p_document_subtype IN PO_TBL_VARCHAR30,
12675: p_document_num IN PO_TBL_VARCHAR30,
12676: p_vendor_order_num IN PO_TBL_VARCHAR30,

Line 12677: p_line_id IN PO_TBL_NUMBER,

12673: p_document_type IN PO_TBL_VARCHAR30,
12674: p_document_subtype IN PO_TBL_VARCHAR30,
12675: p_document_num IN PO_TBL_VARCHAR30,
12676: p_vendor_order_num IN PO_TBL_VARCHAR30,
12677: p_line_id IN PO_TBL_NUMBER,
12678: p_line_location_id IN PO_TBL_NUMBER,
12679: p_distribution_id IN PO_TBL_NUMBER,
12680: p_lock_flag IN VARCHAR2 := 'N',
12681: p_calling_module IN VARCHAR2 := NULL, -- PDOI Rewrite R12

Line 12678: p_line_location_id IN PO_TBL_NUMBER,

12674: p_document_subtype IN PO_TBL_VARCHAR30,
12675: p_document_num IN PO_TBL_VARCHAR30,
12676: p_vendor_order_num IN PO_TBL_VARCHAR30,
12677: p_line_id IN PO_TBL_NUMBER,
12678: p_line_location_id IN PO_TBL_NUMBER,
12679: p_distribution_id IN PO_TBL_NUMBER,
12680: p_lock_flag IN VARCHAR2 := 'N',
12681: p_calling_module IN VARCHAR2 := NULL, -- PDOI Rewrite R12
12682: p_role IN VARCHAR2 := NULL, -- PDOI Rewrite R12

Line 12679: p_distribution_id IN PO_TBL_NUMBER,

12675: p_document_num IN PO_TBL_VARCHAR30,
12676: p_vendor_order_num IN PO_TBL_VARCHAR30,
12677: p_line_id IN PO_TBL_NUMBER,
12678: p_line_location_id IN PO_TBL_NUMBER,
12679: p_distribution_id IN PO_TBL_NUMBER,
12680: p_lock_flag IN VARCHAR2 := 'N',
12681: p_calling_module IN VARCHAR2 := NULL, -- PDOI Rewrite R12
12682: p_role IN VARCHAR2 := NULL, -- PDOI Rewrite R12
12683: p_skip_cat_upload_chk IN VARCHAR2 := NULL, -- PDOI Rewrite R12

Line 12694: l_header_id PO_TBL_NUMBER;

12690: l_document_id PO_HEADERS.po_header_id%TYPE;
12691: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
12692:
12693: -- bug3592160 START
12694: l_header_id PO_TBL_NUMBER;
12695: l_procedure_id PO_SESSION_GT.key%TYPE;
12696: -- bug3592160 END
12697:
12698: --

Line 12908: p_header_id IN PO_TBL_NUMBER,

12904: -------------------------------------------------------------------------------
12905:
12906: PROCEDURE check_reservable (
12907: p_count IN NUMBER,
12908: p_header_id IN PO_TBL_NUMBER,
12909: p_release_id IN PO_TBL_NUMBER,
12910: p_document_type IN PO_TBL_VARCHAR30,
12911: p_document_subtype IN PO_TBL_VARCHAR30,
12912: p_document_num IN PO_TBL_VARCHAR30,

Line 12909: p_release_id IN PO_TBL_NUMBER,

12905:
12906: PROCEDURE check_reservable (
12907: p_count IN NUMBER,
12908: p_header_id IN PO_TBL_NUMBER,
12909: p_release_id IN PO_TBL_NUMBER,
12910: p_document_type IN PO_TBL_VARCHAR30,
12911: p_document_subtype IN PO_TBL_VARCHAR30,
12912: p_document_num IN PO_TBL_VARCHAR30,
12913: p_vendor_order_num IN PO_TBL_VARCHAR30,

Line 12914: p_line_id IN PO_TBL_NUMBER,

12910: p_document_type IN PO_TBL_VARCHAR30,
12911: p_document_subtype IN PO_TBL_VARCHAR30,
12912: p_document_num IN PO_TBL_VARCHAR30,
12913: p_vendor_order_num IN PO_TBL_VARCHAR30,
12914: p_line_id IN PO_TBL_NUMBER,
12915: p_line_location_id IN PO_TBL_NUMBER,
12916: p_distribution_id IN PO_TBL_NUMBER,
12917: p_lock_flag IN VARCHAR2 := 'N',
12918: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,

Line 12915: p_line_location_id IN PO_TBL_NUMBER,

12911: p_document_subtype IN PO_TBL_VARCHAR30,
12912: p_document_num IN PO_TBL_VARCHAR30,
12913: p_vendor_order_num IN PO_TBL_VARCHAR30,
12914: p_line_id IN PO_TBL_NUMBER,
12915: p_line_location_id IN PO_TBL_NUMBER,
12916: p_distribution_id IN PO_TBL_NUMBER,
12917: p_lock_flag IN VARCHAR2 := 'N',
12918: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
12919: x_return_status IN OUT NOCOPY VARCHAR2

Line 12916: p_distribution_id IN PO_TBL_NUMBER,

12912: p_document_num IN PO_TBL_VARCHAR30,
12913: p_vendor_order_num IN PO_TBL_VARCHAR30,
12914: p_line_id IN PO_TBL_NUMBER,
12915: p_line_location_id IN PO_TBL_NUMBER,
12916: p_distribution_id IN PO_TBL_NUMBER,
12917: p_lock_flag IN VARCHAR2 := 'N',
12918: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
12919: x_return_status IN OUT NOCOPY VARCHAR2
12920: ) IS

Line 12928: l_header_id PO_TBL_NUMBER;

12924: l_document_id PO_HEADERS.po_header_id%TYPE;
12925: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
12926:
12927: -- bug3592160 START
12928: l_header_id PO_TBL_NUMBER;
12929: l_procedure_id PO_SESSION_GT.key%TYPE;
12930: -- bug3592160 END
12931:
12932: BEGIN

Line 13081: p_header_id IN PO_TBL_NUMBER,

13077: -------------------------------------------------------------------------------
13078:
13079: PROCEDURE check_unreservable (
13080: p_count IN NUMBER,
13081: p_header_id IN PO_TBL_NUMBER,
13082: p_release_id IN PO_TBL_NUMBER,
13083: p_document_type IN PO_TBL_VARCHAR30,
13084: p_document_subtype IN PO_TBL_VARCHAR30,
13085: p_document_num IN PO_TBL_VARCHAR30,

Line 13082: p_release_id IN PO_TBL_NUMBER,

13078:
13079: PROCEDURE check_unreservable (
13080: p_count IN NUMBER,
13081: p_header_id IN PO_TBL_NUMBER,
13082: p_release_id IN PO_TBL_NUMBER,
13083: p_document_type IN PO_TBL_VARCHAR30,
13084: p_document_subtype IN PO_TBL_VARCHAR30,
13085: p_document_num IN PO_TBL_VARCHAR30,
13086: p_vendor_order_num IN PO_TBL_VARCHAR30,

Line 13087: p_line_id IN PO_TBL_NUMBER,

13083: p_document_type IN PO_TBL_VARCHAR30,
13084: p_document_subtype IN PO_TBL_VARCHAR30,
13085: p_document_num IN PO_TBL_VARCHAR30,
13086: p_vendor_order_num IN PO_TBL_VARCHAR30,
13087: p_line_id IN PO_TBL_NUMBER,
13088: p_line_location_id IN PO_TBL_NUMBER,
13089: p_distribution_id IN PO_TBL_NUMBER,
13090: p_lock_flag IN VARCHAR2 := 'N',
13091: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,

Line 13088: p_line_location_id IN PO_TBL_NUMBER,

13084: p_document_subtype IN PO_TBL_VARCHAR30,
13085: p_document_num IN PO_TBL_VARCHAR30,
13086: p_vendor_order_num IN PO_TBL_VARCHAR30,
13087: p_line_id IN PO_TBL_NUMBER,
13088: p_line_location_id IN PO_TBL_NUMBER,
13089: p_distribution_id IN PO_TBL_NUMBER,
13090: p_lock_flag IN VARCHAR2 := 'N',
13091: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
13092: x_return_status IN OUT NOCOPY VARCHAR2

Line 13089: p_distribution_id IN PO_TBL_NUMBER,

13085: p_document_num IN PO_TBL_VARCHAR30,
13086: p_vendor_order_num IN PO_TBL_VARCHAR30,
13087: p_line_id IN PO_TBL_NUMBER,
13088: p_line_location_id IN PO_TBL_NUMBER,
13089: p_distribution_id IN PO_TBL_NUMBER,
13090: p_lock_flag IN VARCHAR2 := 'N',
13091: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
13092: x_return_status IN OUT NOCOPY VARCHAR2
13093: ) IS

Line 13101: l_header_id PO_TBL_NUMBER;

13097: l_document_id PO_HEADERS.po_header_id%TYPE;
13098: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
13099:
13100: -- bug3592160 START
13101: l_header_id PO_TBL_NUMBER;
13102: l_procedure_id PO_SESSION_GT.key%TYPE;
13103: -- bug3592160 END
13104:
13105: BEGIN

Line 13251: p_header_id IN PO_TBL_NUMBER,

13247: -------------------------------------------------------------------------------
13248:
13249: PROCEDURE get_status (
13250: p_count IN NUMBER,
13251: p_header_id IN PO_TBL_NUMBER,
13252: p_release_id IN PO_TBL_NUMBER,
13253: p_document_type IN PO_TBL_VARCHAR30,
13254: p_document_subtype IN PO_TBL_VARCHAR30,
13255: p_document_num IN PO_TBL_VARCHAR30,

Line 13252: p_release_id IN PO_TBL_NUMBER,

13248:
13249: PROCEDURE get_status (
13250: p_count IN NUMBER,
13251: p_header_id IN PO_TBL_NUMBER,
13252: p_release_id IN PO_TBL_NUMBER,
13253: p_document_type IN PO_TBL_VARCHAR30,
13254: p_document_subtype IN PO_TBL_VARCHAR30,
13255: p_document_num IN PO_TBL_VARCHAR30,
13256: p_vendor_order_num IN PO_TBL_VARCHAR30,

Line 13257: p_line_id IN PO_TBL_NUMBER,

13253: p_document_type IN PO_TBL_VARCHAR30,
13254: p_document_subtype IN PO_TBL_VARCHAR30,
13255: p_document_num IN PO_TBL_VARCHAR30,
13256: p_vendor_order_num IN PO_TBL_VARCHAR30,
13257: p_line_id IN PO_TBL_NUMBER,
13258: p_line_location_id IN PO_TBL_NUMBER,
13259: p_distribution_id IN PO_TBL_NUMBER,
13260: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
13261: x_return_status IN OUT NOCOPY VARCHAR2

Line 13258: p_line_location_id IN PO_TBL_NUMBER,

13254: p_document_subtype IN PO_TBL_VARCHAR30,
13255: p_document_num IN PO_TBL_VARCHAR30,
13256: p_vendor_order_num IN PO_TBL_VARCHAR30,
13257: p_line_id IN PO_TBL_NUMBER,
13258: p_line_location_id IN PO_TBL_NUMBER,
13259: p_distribution_id IN PO_TBL_NUMBER,
13260: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
13261: x_return_status IN OUT NOCOPY VARCHAR2
13262: ) IS

Line 13259: p_distribution_id IN PO_TBL_NUMBER,

13255: p_document_num IN PO_TBL_VARCHAR30,
13256: p_vendor_order_num IN PO_TBL_VARCHAR30,
13257: p_line_id IN PO_TBL_NUMBER,
13258: p_line_location_id IN PO_TBL_NUMBER,
13259: p_distribution_id IN PO_TBL_NUMBER,
13260: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
13261: x_return_status IN OUT NOCOPY VARCHAR2
13262: ) IS
13263:

Line 13266: l_sequence PO_TBL_NUMBER := PO_TBL_NUMBER();

13262: ) IS
13263:
13264: l_api_name CONSTANT VARCHAR(30) := 'GET_STATUS';
13265: l_progress VARCHAR2(3) := '000';
13266: l_sequence PO_TBL_NUMBER := PO_TBL_NUMBER();
13267:
13268: BEGIN
13269:
13270: IF g_debug_stmt THEN

Line 13453: p_header_id IN PO_TBL_NUMBER,

13449: -------------------------------------------------------------------------------
13450:
13451: PROCEDURE po_status_check (
13452: p_api_version IN NUMBER,
13453: p_header_id IN PO_TBL_NUMBER,
13454: p_release_id IN PO_TBL_NUMBER,
13455: p_document_type IN PO_TBL_VARCHAR30,
13456: p_document_subtype IN PO_TBL_VARCHAR30,
13457: p_document_num IN PO_TBL_VARCHAR30,

Line 13454: p_release_id IN PO_TBL_NUMBER,

13450:
13451: PROCEDURE po_status_check (
13452: p_api_version IN NUMBER,
13453: p_header_id IN PO_TBL_NUMBER,
13454: p_release_id IN PO_TBL_NUMBER,
13455: p_document_type IN PO_TBL_VARCHAR30,
13456: p_document_subtype IN PO_TBL_VARCHAR30,
13457: p_document_num IN PO_TBL_VARCHAR30,
13458: p_vendor_order_num IN PO_TBL_VARCHAR30,

Line 13459: p_line_id IN PO_TBL_NUMBER,

13455: p_document_type IN PO_TBL_VARCHAR30,
13456: p_document_subtype IN PO_TBL_VARCHAR30,
13457: p_document_num IN PO_TBL_VARCHAR30,
13458: p_vendor_order_num IN PO_TBL_VARCHAR30,
13459: p_line_id IN PO_TBL_NUMBER,
13460: p_line_location_id IN PO_TBL_NUMBER,
13461: p_distribution_id IN PO_TBL_NUMBER,
13462: p_mode IN VARCHAR2,
13463: p_lock_flag IN VARCHAR2 := 'N',

Line 13460: p_line_location_id IN PO_TBL_NUMBER,

13456: p_document_subtype IN PO_TBL_VARCHAR30,
13457: p_document_num IN PO_TBL_VARCHAR30,
13458: p_vendor_order_num IN PO_TBL_VARCHAR30,
13459: p_line_id IN PO_TBL_NUMBER,
13460: p_line_location_id IN PO_TBL_NUMBER,
13461: p_distribution_id IN PO_TBL_NUMBER,
13462: p_mode IN VARCHAR2,
13463: p_lock_flag IN VARCHAR2 := 'N',
13464: p_calling_module IN VARCHAR2 := NULL, -- PDOI Rewrite R12

Line 13461: p_distribution_id IN PO_TBL_NUMBER,

13457: p_document_num IN PO_TBL_VARCHAR30,
13458: p_vendor_order_num IN PO_TBL_VARCHAR30,
13459: p_line_id IN PO_TBL_NUMBER,
13460: p_line_location_id IN PO_TBL_NUMBER,
13461: p_distribution_id IN PO_TBL_NUMBER,
13462: p_mode IN VARCHAR2,
13463: p_lock_flag IN VARCHAR2 := 'N',
13464: p_calling_module IN VARCHAR2 := NULL, -- PDOI Rewrite R12
13465: p_role IN VARCHAR2 := NULL, -- PDOI Rewrite R12

Line 14020: l_line_location_id_tbl po_tbl_number;

14016:
14017: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'POPULATE_LINE_LOCATIONS_GT';
14018: l_progress VARCHAR2(3) := '000';
14019:
14020: l_line_location_id_tbl po_tbl_number;
14021:
14022: BEGIN
14023:
14024: IF g_debug_stmt THEN

Line 14036: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )

14032:
14033: PO_CORE_S.get_line_location_ids(
14034: p_doc_type => p_doc_type
14035: , p_doc_level => p_doc_level
14036: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )
14037: , x_line_location_id_tbl => l_line_location_id_tbl
14038: );
14039:
14040: l_progress := '020';

Line 14389: l_dist_id_tbl po_tbl_number;

14385:
14386: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'POPULATE_DISTRIBUTIONS_GT';
14387: l_progress VARCHAR2(3) := '000';
14388:
14389: l_dist_id_tbl po_tbl_number;
14390:
14391: BEGIN
14392:
14393: IF g_debug_stmt THEN

Line 14425: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )

14421:
14422: PO_CORE_S.get_distribution_ids(
14423: p_doc_type => p_doc_type
14424: , p_doc_level => p_doc_level
14425: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )
14426: , x_distribution_id_tbl => l_dist_id_tbl
14427: );
14428:
14429: l_progress := '050';

Line 14706: l_line_num_tbl po_tbl_number;

14702: l_msg_name PO_ONLINE_REPORT_TEXT_GT.message_name%TYPE;
14703: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
14704:
14705: l_date_tbl po_tbl_date;
14706: l_line_num_tbl po_tbl_number;
14707: l_shipment_num_tbl po_tbl_number;
14708: l_distribution_num_tbl po_tbl_number;
14709:
14710: l_period_name_tbl po_tbl_varchar30;

Line 14707: l_shipment_num_tbl po_tbl_number;

14703: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
14704:
14705: l_date_tbl po_tbl_date;
14706: l_line_num_tbl po_tbl_number;
14707: l_shipment_num_tbl po_tbl_number;
14708: l_distribution_num_tbl po_tbl_number;
14709:
14710: l_period_name_tbl po_tbl_varchar30;
14711: l_period_year_tbl po_tbl_number;

Line 14708: l_distribution_num_tbl po_tbl_number;

14704:
14705: l_date_tbl po_tbl_date;
14706: l_line_num_tbl po_tbl_number;
14707: l_shipment_num_tbl po_tbl_number;
14708: l_distribution_num_tbl po_tbl_number;
14709:
14710: l_period_name_tbl po_tbl_varchar30;
14711: l_period_year_tbl po_tbl_number;
14712: l_period_num_tbl po_tbl_number;

Line 14711: l_period_year_tbl po_tbl_number;

14707: l_shipment_num_tbl po_tbl_number;
14708: l_distribution_num_tbl po_tbl_number;
14709:
14710: l_period_name_tbl po_tbl_varchar30;
14711: l_period_year_tbl po_tbl_number;
14712: l_period_num_tbl po_tbl_number;
14713: l_quarter_num_tbl po_tbl_number;
14714: l_invalid_period_flag VARCHAR2(1);
14715:

Line 14712: l_period_num_tbl po_tbl_number;

14708: l_distribution_num_tbl po_tbl_number;
14709:
14710: l_period_name_tbl po_tbl_varchar30;
14711: l_period_year_tbl po_tbl_number;
14712: l_period_num_tbl po_tbl_number;
14713: l_quarter_num_tbl po_tbl_number;
14714: l_invalid_period_flag VARCHAR2(1);
14715:
14716: l_dates_key NUMBER;

Line 14713: l_quarter_num_tbl po_tbl_number;

14709:
14710: l_period_name_tbl po_tbl_varchar30;
14711: l_period_year_tbl po_tbl_number;
14712: l_period_num_tbl po_tbl_number;
14713: l_quarter_num_tbl po_tbl_number;
14714: l_invalid_period_flag VARCHAR2(1);
14715:
14716: l_dates_key NUMBER;
14717:

Line 15027: p_header_id IN PO_TBL_NUMBER,

15023: --End of Comments
15024: -------------------------------------------------------------------------------
15025: PROCEDURE complete_po_header_id_tbl
15026: ( p_count IN NUMBER,
15027: p_header_id IN PO_TBL_NUMBER,
15028: p_release_id IN PO_TBL_NUMBER,
15029: p_vendor_order_num IN PO_TBL_VARCHAR30,
15030: p_document_num IN PO_TBL_VARCHAR30,
15031: p_type_lookup_code IN PO_TBL_VARCHAR30,

Line 15028: p_release_id IN PO_TBL_NUMBER,

15024: -------------------------------------------------------------------------------
15025: PROCEDURE complete_po_header_id_tbl
15026: ( p_count IN NUMBER,
15027: p_header_id IN PO_TBL_NUMBER,
15028: p_release_id IN PO_TBL_NUMBER,
15029: p_vendor_order_num IN PO_TBL_VARCHAR30,
15030: p_document_num IN PO_TBL_VARCHAR30,
15031: p_type_lookup_code IN PO_TBL_VARCHAR30,
15032: x_header_id OUT NOCOPY PO_TBL_NUMBER

Line 15032: x_header_id OUT NOCOPY PO_TBL_NUMBER

15028: p_release_id IN PO_TBL_NUMBER,
15029: p_vendor_order_num IN PO_TBL_VARCHAR30,
15030: p_document_num IN PO_TBL_VARCHAR30,
15031: p_type_lookup_code IN PO_TBL_VARCHAR30,
15032: x_header_id OUT NOCOPY PO_TBL_NUMBER
15033: ) IS
15034:
15035: l_api_name CONSTANT VARCHAR2(30) := 'COMPLETE_PO_HEADER_ID_TBL';
15036: l_log_head CONSTANT VARCHAR2(100) := g_log_head|| l_api_name;

Line 15045: x_header_id := PO_TBL_NUMBER();

15041: IF g_debug_stmt THEN
15042: PO_DEBUG.debug_begin(l_log_head);
15043: END IF;
15044:
15045: x_header_id := PO_TBL_NUMBER();
15046: x_header_id.extend(p_count);
15047:
15048: l_progress := '010';
15049: