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 119: p_header_id IN PO_TBL_NUMBER,

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

Line 120: p_release_id IN PO_TBL_NUMBER,

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

Line 124: x_header_id OUT NOCOPY PO_TBL_NUMBER

120: p_release_id IN PO_TBL_NUMBER,
121: p_vendor_order_num IN PO_TBL_VARCHAR30,
122: p_document_num IN PO_TBL_VARCHAR30,
123: p_type_lookup_code IN PO_TBL_VARCHAR30,
124: x_header_id OUT NOCOPY PO_TBL_NUMBER
125: );
126: -- bug3592160 END
127:
128: --

Line 1173: l_id_tbl po_tbl_number;

1169: l_log_head CONSTANT VARCHAR2(100) := g_log_head||l_api_name;
1170: l_progress VARCHAR2(8); --changed from 3 to 8 for bug 13481176
1171:
1172: l_document_id NUMBER;
1173: l_id_tbl po_tbl_number;
1174:
1175: l_num_messages NUMBER := 0; -- bug3574165: Changed l_num_errors to l_num_messages
1176: l_num_warnings NUMBER := 0; -- bug3574165
1177:

Line 1266: , p_doc_level_id_tbl => po_tbl_number( p_document_level_id )

1262:
1263: PO_CORE_S.get_document_ids(
1264: p_doc_type => p_document_type
1265: , p_doc_level => p_document_level
1266: , p_doc_level_id_tbl => po_tbl_number( p_document_level_id )
1267: , x_doc_id_tbl => l_id_tbl
1268: );
1269:
1270: l_document_id := l_id_tbl(1);

Line 13466: l_id_tbl po_tbl_number;

13462: l_return_status VARCHAR2(1);
13463:
13464: l_doc_id NUMBER;
13465:
13466: l_id_tbl po_tbl_number;
13467:
13468: BEGIN
13469: l_progress := '000';
13470:

Line 13498: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )

13494:
13495: PO_CORE_S.get_document_ids(
13496: p_doc_type => p_doc_type
13497: , p_doc_level => p_doc_level
13498: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )
13499: , x_doc_id_tbl => l_id_tbl
13500: );
13501:
13502: l_progress := '510';

Line 14633: l_line_id_tbl po_tbl_number;

14629:
14630: l_api_name CONSTANT varchar2(40) := 'POPULATE_PO_LINES_GT';
14631: l_progress VARCHAR2(3);
14632:
14633: l_line_id_tbl po_tbl_number;
14634: -- PAR Project
14635: l_draft_type VARCHAR2(30);
14636:
14637: BEGIN

Line 14653: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )

14649:
14650: PO_CORE_S.get_line_ids(
14651: p_doc_type => p_doc_type
14652: , p_doc_level => p_doc_level
14653: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )
14654: , p_draft_id => p_draft_id
14655: , x_line_id_tbl => l_line_id_tbl
14656: );
14657:

Line 16190: p_header_id IN PO_TBL_NUMBER,

16186: -------------------------------------------------------------------------------
16187:
16188: PROCEDURE check_updatable (
16189: p_count IN NUMBER,
16190: p_header_id IN PO_TBL_NUMBER,
16191: p_release_id IN PO_TBL_NUMBER,
16192: p_document_type IN PO_TBL_VARCHAR30,
16193: p_document_subtype IN PO_TBL_VARCHAR30,
16194: p_document_num IN PO_TBL_VARCHAR30,

Line 16191: p_release_id IN PO_TBL_NUMBER,

16187:
16188: PROCEDURE check_updatable (
16189: p_count IN NUMBER,
16190: p_header_id IN PO_TBL_NUMBER,
16191: p_release_id IN PO_TBL_NUMBER,
16192: p_document_type IN PO_TBL_VARCHAR30,
16193: p_document_subtype IN PO_TBL_VARCHAR30,
16194: p_document_num IN PO_TBL_VARCHAR30,
16195: p_vendor_order_num IN PO_TBL_VARCHAR30,

Line 16196: p_line_id IN PO_TBL_NUMBER,

16192: p_document_type IN PO_TBL_VARCHAR30,
16193: p_document_subtype IN PO_TBL_VARCHAR30,
16194: p_document_num IN PO_TBL_VARCHAR30,
16195: p_vendor_order_num IN PO_TBL_VARCHAR30,
16196: p_line_id IN PO_TBL_NUMBER,
16197: p_line_location_id IN PO_TBL_NUMBER,
16198: p_distribution_id IN PO_TBL_NUMBER,
16199: p_lock_flag IN VARCHAR2 := 'N',
16200: p_calling_module IN VARCHAR2 := NULL, -- PDOI Rewrite R12

Line 16197: p_line_location_id IN PO_TBL_NUMBER,

16193: p_document_subtype IN PO_TBL_VARCHAR30,
16194: p_document_num IN PO_TBL_VARCHAR30,
16195: p_vendor_order_num IN PO_TBL_VARCHAR30,
16196: p_line_id IN PO_TBL_NUMBER,
16197: p_line_location_id IN PO_TBL_NUMBER,
16198: p_distribution_id IN PO_TBL_NUMBER,
16199: p_lock_flag IN VARCHAR2 := 'N',
16200: p_calling_module IN VARCHAR2 := NULL, -- PDOI Rewrite R12
16201: p_role IN VARCHAR2 := NULL, -- PDOI Rewrite R12

Line 16198: p_distribution_id IN PO_TBL_NUMBER,

16194: p_document_num IN PO_TBL_VARCHAR30,
16195: p_vendor_order_num IN PO_TBL_VARCHAR30,
16196: p_line_id IN PO_TBL_NUMBER,
16197: p_line_location_id IN PO_TBL_NUMBER,
16198: p_distribution_id IN PO_TBL_NUMBER,
16199: p_lock_flag IN VARCHAR2 := 'N',
16200: p_calling_module IN VARCHAR2 := NULL, -- PDOI Rewrite R12
16201: p_role IN VARCHAR2 := NULL, -- PDOI Rewrite R12
16202: p_skip_cat_upload_chk IN VARCHAR2 := NULL, -- PDOI Rewrite R12

Line 16213: l_header_id PO_TBL_NUMBER;

16209: l_document_id PO_HEADERS.po_header_id%TYPE;
16210: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
16211:
16212: -- bug3592160 START
16213: l_header_id PO_TBL_NUMBER;
16214: l_procedure_id PO_SESSION_GT.key%TYPE;
16215: -- bug3592160 END
16216:
16217: --

Line 16427: p_header_id IN PO_TBL_NUMBER,

16423: -------------------------------------------------------------------------------
16424:
16425: PROCEDURE check_reservable (
16426: p_count IN NUMBER,
16427: p_header_id IN PO_TBL_NUMBER,
16428: p_release_id IN PO_TBL_NUMBER,
16429: p_document_type IN PO_TBL_VARCHAR30,
16430: p_document_subtype IN PO_TBL_VARCHAR30,
16431: p_document_num IN PO_TBL_VARCHAR30,

Line 16428: p_release_id IN PO_TBL_NUMBER,

16424:
16425: PROCEDURE check_reservable (
16426: p_count IN NUMBER,
16427: p_header_id IN PO_TBL_NUMBER,
16428: p_release_id IN PO_TBL_NUMBER,
16429: p_document_type IN PO_TBL_VARCHAR30,
16430: p_document_subtype IN PO_TBL_VARCHAR30,
16431: p_document_num IN PO_TBL_VARCHAR30,
16432: p_vendor_order_num IN PO_TBL_VARCHAR30,

Line 16433: p_line_id IN PO_TBL_NUMBER,

16429: p_document_type IN PO_TBL_VARCHAR30,
16430: p_document_subtype IN PO_TBL_VARCHAR30,
16431: p_document_num IN PO_TBL_VARCHAR30,
16432: p_vendor_order_num IN PO_TBL_VARCHAR30,
16433: p_line_id IN PO_TBL_NUMBER,
16434: p_line_location_id IN PO_TBL_NUMBER,
16435: p_distribution_id IN PO_TBL_NUMBER,
16436: p_lock_flag IN VARCHAR2 := 'N',
16437: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,

Line 16434: p_line_location_id IN PO_TBL_NUMBER,

16430: p_document_subtype IN PO_TBL_VARCHAR30,
16431: p_document_num IN PO_TBL_VARCHAR30,
16432: p_vendor_order_num IN PO_TBL_VARCHAR30,
16433: p_line_id IN PO_TBL_NUMBER,
16434: p_line_location_id IN PO_TBL_NUMBER,
16435: p_distribution_id IN PO_TBL_NUMBER,
16436: p_lock_flag IN VARCHAR2 := 'N',
16437: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
16438: x_return_status IN OUT NOCOPY VARCHAR2

Line 16435: p_distribution_id IN PO_TBL_NUMBER,

16431: p_document_num IN PO_TBL_VARCHAR30,
16432: p_vendor_order_num IN PO_TBL_VARCHAR30,
16433: p_line_id IN PO_TBL_NUMBER,
16434: p_line_location_id IN PO_TBL_NUMBER,
16435: p_distribution_id IN PO_TBL_NUMBER,
16436: p_lock_flag IN VARCHAR2 := 'N',
16437: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
16438: x_return_status IN OUT NOCOPY VARCHAR2
16439: ) IS

Line 16447: l_header_id PO_TBL_NUMBER;

16443: l_document_id PO_HEADERS.po_header_id%TYPE;
16444: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
16445:
16446: -- bug3592160 START
16447: l_header_id PO_TBL_NUMBER;
16448: l_procedure_id PO_SESSION_GT.key%TYPE;
16449: -- bug3592160 END
16450:
16451: BEGIN

Line 16605: p_header_id IN PO_TBL_NUMBER,

16601: -------------------------------------------------------------------------------
16602:
16603: PROCEDURE check_unreservable (
16604: p_count IN NUMBER,
16605: p_header_id IN PO_TBL_NUMBER,
16606: p_release_id IN PO_TBL_NUMBER,
16607: p_document_type IN PO_TBL_VARCHAR30,
16608: p_document_subtype IN PO_TBL_VARCHAR30,
16609: p_document_num IN PO_TBL_VARCHAR30,

Line 16606: p_release_id IN PO_TBL_NUMBER,

16602:
16603: PROCEDURE check_unreservable (
16604: p_count IN NUMBER,
16605: p_header_id IN PO_TBL_NUMBER,
16606: p_release_id IN PO_TBL_NUMBER,
16607: p_document_type IN PO_TBL_VARCHAR30,
16608: p_document_subtype IN PO_TBL_VARCHAR30,
16609: p_document_num IN PO_TBL_VARCHAR30,
16610: p_vendor_order_num IN PO_TBL_VARCHAR30,

Line 16611: p_line_id IN PO_TBL_NUMBER,

16607: p_document_type IN PO_TBL_VARCHAR30,
16608: p_document_subtype IN PO_TBL_VARCHAR30,
16609: p_document_num IN PO_TBL_VARCHAR30,
16610: p_vendor_order_num IN PO_TBL_VARCHAR30,
16611: p_line_id IN PO_TBL_NUMBER,
16612: p_line_location_id IN PO_TBL_NUMBER,
16613: p_distribution_id IN PO_TBL_NUMBER,
16614: p_lock_flag IN VARCHAR2 := 'N',
16615: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,

Line 16612: p_line_location_id IN PO_TBL_NUMBER,

16608: p_document_subtype IN PO_TBL_VARCHAR30,
16609: p_document_num IN PO_TBL_VARCHAR30,
16610: p_vendor_order_num IN PO_TBL_VARCHAR30,
16611: p_line_id IN PO_TBL_NUMBER,
16612: p_line_location_id IN PO_TBL_NUMBER,
16613: p_distribution_id IN PO_TBL_NUMBER,
16614: p_lock_flag IN VARCHAR2 := 'N',
16615: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
16616: x_return_status IN OUT NOCOPY VARCHAR2

Line 16613: p_distribution_id IN PO_TBL_NUMBER,

16609: p_document_num IN PO_TBL_VARCHAR30,
16610: p_vendor_order_num IN PO_TBL_VARCHAR30,
16611: p_line_id IN PO_TBL_NUMBER,
16612: p_line_location_id IN PO_TBL_NUMBER,
16613: p_distribution_id IN PO_TBL_NUMBER,
16614: p_lock_flag IN VARCHAR2 := 'N',
16615: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
16616: x_return_status IN OUT NOCOPY VARCHAR2
16617: ) IS

Line 16625: l_header_id PO_TBL_NUMBER;

16621: l_document_id PO_HEADERS.po_header_id%TYPE;
16622: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
16623:
16624: -- bug3592160 START
16625: l_header_id PO_TBL_NUMBER;
16626: l_procedure_id PO_SESSION_GT.key%TYPE;
16627: -- bug3592160 END
16628:
16629: BEGIN

Line 16775: p_header_id IN PO_TBL_NUMBER,

16771: -------------------------------------------------------------------------------
16772:
16773: PROCEDURE get_status (
16774: p_count IN NUMBER,
16775: p_header_id IN PO_TBL_NUMBER,
16776: p_release_id IN PO_TBL_NUMBER,
16777: p_document_type IN PO_TBL_VARCHAR30,
16778: p_document_subtype IN PO_TBL_VARCHAR30,
16779: p_document_num IN PO_TBL_VARCHAR30,

Line 16776: p_release_id IN PO_TBL_NUMBER,

16772:
16773: PROCEDURE get_status (
16774: p_count IN NUMBER,
16775: p_header_id IN PO_TBL_NUMBER,
16776: p_release_id IN PO_TBL_NUMBER,
16777: p_document_type IN PO_TBL_VARCHAR30,
16778: p_document_subtype IN PO_TBL_VARCHAR30,
16779: p_document_num IN PO_TBL_VARCHAR30,
16780: p_vendor_order_num IN PO_TBL_VARCHAR30,

Line 16781: p_line_id IN PO_TBL_NUMBER,

16777: p_document_type IN PO_TBL_VARCHAR30,
16778: p_document_subtype IN PO_TBL_VARCHAR30,
16779: p_document_num IN PO_TBL_VARCHAR30,
16780: p_vendor_order_num IN PO_TBL_VARCHAR30,
16781: p_line_id IN PO_TBL_NUMBER,
16782: p_line_location_id IN PO_TBL_NUMBER,
16783: p_distribution_id IN PO_TBL_NUMBER,
16784: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
16785: x_return_status IN OUT NOCOPY VARCHAR2

Line 16782: p_line_location_id IN PO_TBL_NUMBER,

16778: p_document_subtype IN PO_TBL_VARCHAR30,
16779: p_document_num IN PO_TBL_VARCHAR30,
16780: p_vendor_order_num IN PO_TBL_VARCHAR30,
16781: p_line_id IN PO_TBL_NUMBER,
16782: p_line_location_id IN PO_TBL_NUMBER,
16783: p_distribution_id IN PO_TBL_NUMBER,
16784: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
16785: x_return_status IN OUT NOCOPY VARCHAR2
16786: ) IS

Line 16783: p_distribution_id IN PO_TBL_NUMBER,

16779: p_document_num IN PO_TBL_VARCHAR30,
16780: p_vendor_order_num IN PO_TBL_VARCHAR30,
16781: p_line_id IN PO_TBL_NUMBER,
16782: p_line_location_id IN PO_TBL_NUMBER,
16783: p_distribution_id IN PO_TBL_NUMBER,
16784: x_po_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
16785: x_return_status IN OUT NOCOPY VARCHAR2
16786: ) IS
16787:

Line 16790: l_sequence PO_TBL_NUMBER := PO_TBL_NUMBER();

16786: ) IS
16787:
16788: l_api_name CONSTANT VARCHAR(30) := 'GET_STATUS';
16789: l_progress VARCHAR2(3) := '000';
16790: l_sequence PO_TBL_NUMBER := PO_TBL_NUMBER();
16791:
16792: BEGIN
16793:
16794: IF g_debug_stmt THEN

Line 16977: p_header_id IN PO_TBL_NUMBER,

16973: -------------------------------------------------------------------------------
16974:
16975: PROCEDURE po_status_check (
16976: p_api_version IN NUMBER,
16977: p_header_id IN PO_TBL_NUMBER,
16978: p_release_id IN PO_TBL_NUMBER,
16979: p_document_type IN PO_TBL_VARCHAR30,
16980: p_document_subtype IN PO_TBL_VARCHAR30,
16981: p_document_num IN PO_TBL_VARCHAR30,

Line 16978: p_release_id IN PO_TBL_NUMBER,

16974:
16975: PROCEDURE po_status_check (
16976: p_api_version IN NUMBER,
16977: p_header_id IN PO_TBL_NUMBER,
16978: p_release_id IN PO_TBL_NUMBER,
16979: p_document_type IN PO_TBL_VARCHAR30,
16980: p_document_subtype IN PO_TBL_VARCHAR30,
16981: p_document_num IN PO_TBL_VARCHAR30,
16982: p_vendor_order_num IN PO_TBL_VARCHAR30,

Line 16983: p_line_id IN PO_TBL_NUMBER,

16979: p_document_type IN PO_TBL_VARCHAR30,
16980: p_document_subtype IN PO_TBL_VARCHAR30,
16981: p_document_num IN PO_TBL_VARCHAR30,
16982: p_vendor_order_num IN PO_TBL_VARCHAR30,
16983: p_line_id IN PO_TBL_NUMBER,
16984: p_line_location_id IN PO_TBL_NUMBER,
16985: p_distribution_id IN PO_TBL_NUMBER,
16986: p_mode IN VARCHAR2,
16987: p_lock_flag IN VARCHAR2 := 'N',

Line 16984: p_line_location_id IN PO_TBL_NUMBER,

16980: p_document_subtype IN PO_TBL_VARCHAR30,
16981: p_document_num IN PO_TBL_VARCHAR30,
16982: p_vendor_order_num IN PO_TBL_VARCHAR30,
16983: p_line_id IN PO_TBL_NUMBER,
16984: p_line_location_id IN PO_TBL_NUMBER,
16985: p_distribution_id IN PO_TBL_NUMBER,
16986: p_mode IN VARCHAR2,
16987: p_lock_flag IN VARCHAR2 := 'N',
16988: p_calling_module IN VARCHAR2 := NULL, -- PDOI Rewrite R12

Line 16985: p_distribution_id IN PO_TBL_NUMBER,

16981: p_document_num IN PO_TBL_VARCHAR30,
16982: p_vendor_order_num IN PO_TBL_VARCHAR30,
16983: p_line_id IN PO_TBL_NUMBER,
16984: p_line_location_id IN PO_TBL_NUMBER,
16985: p_distribution_id IN PO_TBL_NUMBER,
16986: p_mode IN VARCHAR2,
16987: p_lock_flag IN VARCHAR2 := 'N',
16988: p_calling_module IN VARCHAR2 := NULL, -- PDOI Rewrite R12
16989: p_role IN VARCHAR2 := NULL, -- PDOI Rewrite R12

Line 17543: l_line_location_id_tbl po_tbl_number;

17539:
17540: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'POPULATE_LINE_LOCATIONS_GT';
17541: l_progress VARCHAR2(3) := '000';
17542:
17543: l_line_location_id_tbl po_tbl_number;
17544: -- PAR Project
17545: l_draft_type VARCHAR2(30);
17546:
17547: BEGIN

Line 17562: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )

17558:
17559: PO_CORE_S.get_line_location_ids(
17560: p_doc_type => p_doc_type
17561: , p_doc_level => p_doc_level
17562: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )
17563: , p_draft_id => p_draft_id
17564: , x_line_location_id_tbl => l_line_location_id_tbl
17565: );
17566:

Line 17960: l_dist_id_tbl po_tbl_number;

17956:
17957: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'POPULATE_DISTRIBUTIONS_GT';
17958: l_progress VARCHAR2(3) := '000';
17959:
17960: l_dist_id_tbl po_tbl_number;
17961: -- PAR Project
17962: l_draft_type VARCHAR2(30);
17963:
17964: BEGIN

Line 17999: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )

17995:
17996: PO_CORE_S.get_distribution_ids(
17997: p_doc_type => p_doc_type
17998: , p_doc_level => p_doc_level
17999: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )
18000: , p_draft_id => p_draft_id
18001: , x_distribution_id_tbl => l_dist_id_tbl
18002: );
18003:

Line 18309: l_line_num_tbl po_tbl_number;

18305: l_msg_name PO_ONLINE_REPORT_TEXT_GT.message_name%TYPE;
18306: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
18307:
18308: l_date_tbl po_tbl_date;
18309: l_line_num_tbl po_tbl_number;
18310: l_shipment_num_tbl po_tbl_number;
18311: l_distribution_num_tbl po_tbl_number;
18312:
18313: l_period_name_tbl po_tbl_varchar30;

Line 18310: l_shipment_num_tbl po_tbl_number;

18306: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
18307:
18308: l_date_tbl po_tbl_date;
18309: l_line_num_tbl po_tbl_number;
18310: l_shipment_num_tbl po_tbl_number;
18311: l_distribution_num_tbl po_tbl_number;
18312:
18313: l_period_name_tbl po_tbl_varchar30;
18314: l_period_year_tbl po_tbl_number;

Line 18311: l_distribution_num_tbl po_tbl_number;

18307:
18308: l_date_tbl po_tbl_date;
18309: l_line_num_tbl po_tbl_number;
18310: l_shipment_num_tbl po_tbl_number;
18311: l_distribution_num_tbl po_tbl_number;
18312:
18313: l_period_name_tbl po_tbl_varchar30;
18314: l_period_year_tbl po_tbl_number;
18315: l_period_num_tbl po_tbl_number;

Line 18314: l_period_year_tbl po_tbl_number;

18310: l_shipment_num_tbl po_tbl_number;
18311: l_distribution_num_tbl po_tbl_number;
18312:
18313: l_period_name_tbl po_tbl_varchar30;
18314: l_period_year_tbl po_tbl_number;
18315: l_period_num_tbl po_tbl_number;
18316: l_quarter_num_tbl po_tbl_number;
18317: l_invalid_period_flag VARCHAR2(1);
18318:

Line 18315: l_period_num_tbl po_tbl_number;

18311: l_distribution_num_tbl po_tbl_number;
18312:
18313: l_period_name_tbl po_tbl_varchar30;
18314: l_period_year_tbl po_tbl_number;
18315: l_period_num_tbl po_tbl_number;
18316: l_quarter_num_tbl po_tbl_number;
18317: l_invalid_period_flag VARCHAR2(1);
18318:
18319: l_dates_key NUMBER;

Line 18316: l_quarter_num_tbl po_tbl_number;

18312:
18313: l_period_name_tbl po_tbl_varchar30;
18314: l_period_year_tbl po_tbl_number;
18315: l_period_num_tbl po_tbl_number;
18316: l_quarter_num_tbl po_tbl_number;
18317: l_invalid_period_flag VARCHAR2(1);
18318:
18319: l_dates_key NUMBER;
18320:

Line 18637: p_header_id IN PO_TBL_NUMBER,

18633: --End of Comments
18634: -------------------------------------------------------------------------------
18635: PROCEDURE complete_po_header_id_tbl
18636: ( p_count IN NUMBER,
18637: p_header_id IN PO_TBL_NUMBER,
18638: p_release_id IN PO_TBL_NUMBER,
18639: p_vendor_order_num IN PO_TBL_VARCHAR30,
18640: p_document_num IN PO_TBL_VARCHAR30,
18641: p_type_lookup_code IN PO_TBL_VARCHAR30,

Line 18638: p_release_id IN PO_TBL_NUMBER,

18634: -------------------------------------------------------------------------------
18635: PROCEDURE complete_po_header_id_tbl
18636: ( p_count IN NUMBER,
18637: p_header_id IN PO_TBL_NUMBER,
18638: p_release_id IN PO_TBL_NUMBER,
18639: p_vendor_order_num IN PO_TBL_VARCHAR30,
18640: p_document_num IN PO_TBL_VARCHAR30,
18641: p_type_lookup_code IN PO_TBL_VARCHAR30,
18642: x_header_id OUT NOCOPY PO_TBL_NUMBER

Line 18642: x_header_id OUT NOCOPY PO_TBL_NUMBER

18638: p_release_id IN PO_TBL_NUMBER,
18639: p_vendor_order_num IN PO_TBL_VARCHAR30,
18640: p_document_num IN PO_TBL_VARCHAR30,
18641: p_type_lookup_code IN PO_TBL_VARCHAR30,
18642: x_header_id OUT NOCOPY PO_TBL_NUMBER
18643: ) IS
18644:
18645: l_api_name CONSTANT VARCHAR2(30) := 'COMPLETE_PO_HEADER_ID_TBL';
18646: l_log_head CONSTANT VARCHAR2(100) := g_log_head|| l_api_name;

Line 18655: x_header_id := PO_TBL_NUMBER();

18651: IF g_debug_stmt THEN
18652: PO_DEBUG.debug_begin(l_log_head);
18653: END IF;
18654:
18655: x_header_id := PO_TBL_NUMBER();
18656: x_header_id.extend(p_count);
18657:
18658: l_progress := '010';
18659: