APPS.PO_AUTOCREATE_GROUPING_PVT dependencies on PO_TBL_VARCHAR1

Line 131: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

127:
128: FUNCTION group_by_default
129: ( p_req_line_id_tbl IN PO_TBL_NUMBER
130: , p_po_line_num_tbl IN PO_TBL_NUMBER
131: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
132: , p_add_to_po_header_id IN NUMBER
133: , p_builder_agreement_id IN NUMBER
134: , p_start_index IN NUMBER
135: , p_end_index IN NUMBER

Line 144: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

140: ) RETURN BOOLEAN;
141:
142: PROCEDURE match_add_to_po_lines
143: ( p_req_line_id_tbl IN PO_TBL_NUMBER
144: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
145: , p_add_to_po_header_id IN NUMBER
146: , p_builder_agreement_id IN NUMBER
147: , p_start_index IN NUMBER
148: , p_end_index IN NUMBER

Line 176: ) RETURN PO_TBL_VARCHAR1;

172: ( p_req_line_id_tbl IN PO_TBL_NUMBER
173: , p_builder_org_id IN NUMBER
174: , p_builder_supplier_id IN NUMBER
175: , p_builder_site_id IN NUMBER
176: ) RETURN PO_TBL_VARCHAR1;
177:
178: FUNCTION find_matching_po_line_num
179: ( p_req_line_id IN NUMBER
180: , p_comparison_tbl IN PO_TBL_NUMBER

Line 348: l_line_combined_flag_tbl PO_TBL_VARCHAR1;

344: l_progress_payment_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
345: l_message_code VARCHAR2(30) := NULL;
346: l_token_name VARCHAR2(30) := NULL;
347: l_token_value VARCHAR2(2000) := NULL;
348: l_line_combined_flag_tbl PO_TBL_VARCHAR1;
349: l_line_combined_flag VARCHAR2(1);
350:
351: CURSOR req_line_ids_csr(
352: c_key IN NUMBER,

Line 385: l_line_combined_flag_tbl := PO_TBL_VARCHAR1();

381: x_token_value_tbl := PO_TBL_VARCHAR2000();
382: x_token_value_tbl.EXTEND(l_num_lines);
383:
384: -- Initialize table of flags indicating whether lines are combined.
385: l_line_combined_flag_tbl := PO_TBL_VARCHAR1();
386: l_line_combined_flag_tbl.EXTEND(l_num_lines);
387:
388: -- Get a new session key for use with the temp table.
389: l_key := PO_CORE_S.get_session_gt_nextval;

Line 758: l_consigned_flag_tbl PO_TBL_VARCHAR1;

754: IS
755: l_start_index NUMBER;
756: l_end_index NUMBER;
757:
758: l_consigned_flag_tbl PO_TBL_VARCHAR1;
759: l_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
760: x_po_line_num_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
761:
762: d_mod CONSTANT VARCHAR2(100) := D_group_req_lines;

Line 2043: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

2039: FUNCTION group_by_default
2040: (
2041: p_req_line_id_tbl IN PO_TBL_NUMBER
2042: , p_po_line_num_tbl IN PO_TBL_NUMBER
2043: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
2044: , p_add_to_po_header_id IN NUMBER
2045: , p_builder_agreement_id IN NUMBER
2046: , p_start_index IN NUMBER
2047: , p_end_index IN NUMBER

Line 2285: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

2281: -------------------------------------------------------------------------------
2282: PROCEDURE match_add_to_po_lines
2283: (
2284: p_req_line_id_tbl IN PO_TBL_NUMBER
2285: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
2286: , p_add_to_po_header_id IN NUMBER
2287: , p_builder_agreement_id IN NUMBER
2288: , p_start_index IN NUMBER
2289: , p_end_index IN NUMBER

Line 2681: RETURN PO_TBL_VARCHAR1

2677: , p_builder_org_id IN NUMBER
2678: , p_builder_supplier_id IN NUMBER
2679: , p_builder_site_id IN NUMBER
2680: )
2681: RETURN PO_TBL_VARCHAR1
2682: IS
2683: l_item_id NUMBER;
2684: x_consigned_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
2685:

Line 2684: x_consigned_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

2680: )
2681: RETURN PO_TBL_VARCHAR1
2682: IS
2683: l_item_id NUMBER;
2684: x_consigned_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
2685:
2686: d_mod CONSTANT VARCHAR2(100) := D_get_consigned_flag_tbl;
2687: d_position NUMBER := 0;
2688: