DBA Data[Home] [Help]

APPS.PON_CLM_CLO_UTIL_PKG dependencies on PO_TBL_VARCHAR100

Line 521: clin_num_tbl po_tbl_varchar100 := po_tbl_varchar100();

517: --p_auction_header_id NUMBER := 123985;
518: --p_clin_line_number NUMBER := 1;
519:
520: -- following fields used for clin numbering after copying the record
521: clin_num_tbl po_tbl_varchar100 := po_tbl_varchar100();
522: next_clin_num VARCHAR2(10);
523:
524: base_line_numbers numbers := numbers();
525: copied_base_line_numbers numbers := numbers();

Line 785: clin_num_tbl := po_tbl_varchar100();

781:
782: EXCEPTION
783: WHEN No_Data_Found THEN
784: --l_max_clin := '0000';
785: clin_num_tbl := po_tbl_varchar100();
786: END;
787:
788: next_clin_num := pon_clo_renumber_pkg.next_clin_num(clin_num_tbl);
789:

Line 1931: clin_num_tbl po_tbl_varchar100 := po_tbl_varchar100();

1927: l_exhibit_number VARCHAR2(2);
1928: --p_auction_header_id NUMBER := 123985;
1929: --p_clin_line_number NUMBER := 1;
1930: -- following fields used for clin numbering after copying the record
1931: clin_num_tbl po_tbl_varchar100 := po_tbl_varchar100();
1932: next_clin_num VARCHAR2(10);
1933: base_line_numbers numbers := numbers();
1934: copied_base_line_numbers numbers := numbers();
1935: LEN NUMBER;

Line 2242: clin_num_tbl := po_tbl_varchar100();

2238: ORDER BY line_num_display;
2239: EXCEPTION
2240: WHEN No_Data_Found THEN
2241: --l_max_clin := '0000';
2242: clin_num_tbl := po_tbl_varchar100();
2243: END;
2244: next_clin_num := pon_clo_renumber_pkg.next_clin_num(clin_num_tbl);
2245: -- this query selects new copied clin and its optional clins if any
2246: SELECT line_number,exhibit_number BULK COLLECT