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

Line 115: ( p_req_line_num_tbl IN PO_TBL_NUMBER

111: x_token_value OUT NOCOPY VARCHAR2
112: );
113:
114: FUNCTION group_by_requisition_line_num
115: ( p_req_line_num_tbl IN PO_TBL_NUMBER
116: , p_po_line_num_tbl IN PO_TBL_NUMBER
117: , p_start_index IN NUMBER
118: , p_end_index IN NUMBER
119: ) RETURN PO_TBL_NUMBER;

Line 116: , p_po_line_num_tbl IN PO_TBL_NUMBER

112: );
113:
114: FUNCTION group_by_requisition_line_num
115: ( p_req_line_num_tbl IN PO_TBL_NUMBER
116: , p_po_line_num_tbl IN PO_TBL_NUMBER
117: , p_start_index IN NUMBER
118: , p_end_index IN NUMBER
119: ) RETURN PO_TBL_NUMBER;
120:

Line 119: ) RETURN PO_TBL_NUMBER;

115: ( p_req_line_num_tbl IN PO_TBL_NUMBER
116: , p_po_line_num_tbl IN PO_TBL_NUMBER
117: , p_start_index IN NUMBER
118: , p_end_index IN NUMBER
119: ) RETURN PO_TBL_NUMBER;
120:
121: FUNCTION group_by_requisition_seq_num
122: ( p_po_line_num_tbl IN PO_TBL_NUMBER
123: , p_add_to_po_header_id IN NUMBER

Line 122: ( p_po_line_num_tbl IN PO_TBL_NUMBER

118: , p_end_index IN NUMBER
119: ) RETURN PO_TBL_NUMBER;
120:
121: FUNCTION group_by_requisition_seq_num
122: ( p_po_line_num_tbl IN PO_TBL_NUMBER
123: , p_add_to_po_header_id IN NUMBER
124: , p_start_index IN NUMBER
125: , p_end_index IN NUMBER
126: ) RETURN PO_TBL_NUMBER;

Line 126: ) RETURN PO_TBL_NUMBER;

122: ( p_po_line_num_tbl IN PO_TBL_NUMBER
123: , p_add_to_po_header_id IN NUMBER
124: , p_start_index IN NUMBER
125: , p_end_index IN NUMBER
126: ) RETURN PO_TBL_NUMBER;
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

Line 129: ( p_req_line_id_tbl IN PO_TBL_NUMBER

125: , p_end_index IN NUMBER
126: ) RETURN PO_TBL_NUMBER;
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

Line 130: , p_po_line_num_tbl IN PO_TBL_NUMBER

126: ) RETURN PO_TBL_NUMBER;
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

Line 136: ) RETURN PO_TBL_NUMBER;

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
136: ) RETURN PO_TBL_NUMBER;
137:
138: FUNCTION has_same_req_header
139: ( p_req_line_id_tbl IN PO_TBL_NUMBER
140: ) RETURN BOOLEAN;

Line 139: ( p_req_line_id_tbl IN PO_TBL_NUMBER

135: , p_end_index IN NUMBER
136: ) RETURN PO_TBL_NUMBER;
137:
138: FUNCTION has_same_req_header
139: ( p_req_line_id_tbl IN PO_TBL_NUMBER
140: ) RETURN BOOLEAN;
141:
142: PROCEDURE match_add_to_po_lines
143: ( p_req_line_id_tbl IN PO_TBL_NUMBER

Line 143: ( p_req_line_id_tbl IN PO_TBL_NUMBER

139: ( p_req_line_id_tbl IN PO_TBL_NUMBER
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

Line 149: , x_req_line_id_tbl OUT NOCOPY PO_TBL_NUMBER

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
149: , x_req_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
150: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER
151: );
152:
153: FUNCTION find_matching_builder_line_num

Line 150: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER

146: , p_builder_agreement_id IN NUMBER
147: , p_start_index IN NUMBER
148: , p_end_index IN NUMBER
149: , x_req_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
150: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER
151: );
152:
153: FUNCTION find_matching_builder_line_num
154: ( p_current_index IN NUMBER

Line 155: , p_req_line_id_tbl IN PO_TBL_NUMBER

151: );
152:
153: FUNCTION find_matching_builder_line_num
154: ( p_current_index IN NUMBER
155: , p_req_line_id_tbl IN PO_TBL_NUMBER
156: , p_po_line_num_tbl IN PO_TBL_NUMBER
157: , p_builder_agreement_id IN NUMBER
158: ) RETURN NUMBER;
159:

Line 156: , p_po_line_num_tbl IN PO_TBL_NUMBER

152:
153: FUNCTION find_matching_builder_line_num
154: ( p_current_index IN NUMBER
155: , p_req_line_id_tbl IN PO_TBL_NUMBER
156: , p_po_line_num_tbl IN PO_TBL_NUMBER
157: , p_builder_agreement_id IN NUMBER
158: ) RETURN NUMBER;
159:
160: FUNCTION req_lines_match

Line 167: ( p_po_line_num_tbl IN PO_TBL_NUMBER

163: , p_req_line_id_2 IN NUMBER
164: ) RETURN BOOLEAN;
165:
166: FUNCTION get_max_po_line_num
167: ( p_po_line_num_tbl IN PO_TBL_NUMBER
168: , p_po_header_id IN NUMBER := NULL
169: ) RETURN NUMBER;
170:
171: FUNCTION get_consigned_flag_tbl

Line 172: ( p_req_line_id_tbl IN PO_TBL_NUMBER

168: , p_po_header_id IN NUMBER := NULL
169: ) RETURN NUMBER;
170:
171: FUNCTION get_consigned_flag_tbl
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;

Line 180: , p_comparison_tbl IN PO_TBL_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
181: , p_po_line_num_tbl IN PO_TBL_NUMBER
182: ) RETURN NUMBER;
183:
184: /*=========================================================================*/

Line 181: , p_po_line_num_tbl IN PO_TBL_NUMBER

177:
178: FUNCTION find_matching_po_line_num
179: ( p_req_line_id IN NUMBER
180: , p_comparison_tbl IN PO_TBL_NUMBER
181: , p_po_line_num_tbl IN PO_TBL_NUMBER
182: ) RETURN NUMBER;
183:
184: /*=========================================================================*/
185: /*========================== BODY (PUBLIC) ================================*/

Line 221: p_po_line_number_tbl IN PO_TBL_NUMBER,

217: -- None
218: --End of Comments
219: -------------------------------------------------------------------------------
220: FUNCTION get_line_action_tbl(
221: p_po_line_number_tbl IN PO_TBL_NUMBER,
222: p_add_to_po_header_id IN NUMBER
223: ) RETURN PO_TBL_VARCHAR5
224: IS
225: d_mod CONSTANT VARCHAR2(100) := D_get_line_action_tbl;

Line 327: p_req_line_id_tbl IN PO_TBL_NUMBER,

323: p_style_id IN NUMBER,
324: p_agreement_id IN NUMBER,
325: p_supplier_id IN NUMBER,
326: p_site_id IN NUMBER,
327: p_req_line_id_tbl IN PO_TBL_NUMBER,
328: p_po_line_number_tbl IN PO_TBL_NUMBER,
329: p_add_to_po_header_id IN NUMBER,
330: x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
331: x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 328: p_po_line_number_tbl IN PO_TBL_NUMBER,

324: p_agreement_id IN NUMBER,
325: p_supplier_id IN NUMBER,
326: p_site_id IN NUMBER,
327: p_req_line_id_tbl IN PO_TBL_NUMBER,
328: p_po_line_number_tbl IN PO_TBL_NUMBER,
329: p_add_to_po_header_id IN NUMBER,
330: x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
331: x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,
332: x_token_value_tbl OUT NOCOPY PO_TBL_VARCHAR2000

Line 741: p_req_line_id_tbl IN PO_TBL_NUMBER

737: --End of Comments
738: -------------------------------------------------------------------------------
739: FUNCTION group_req_lines
740: (
741: p_req_line_id_tbl IN PO_TBL_NUMBER
742: , p_req_line_num_tbl IN PO_TBL_NUMBER
743: , p_po_line_num_tbl IN PO_TBL_NUMBER
744: , p_add_to_po_header_id IN NUMBER
745: , p_builder_agreement_id IN NUMBER

Line 742: , p_req_line_num_tbl IN PO_TBL_NUMBER

738: -------------------------------------------------------------------------------
739: FUNCTION group_req_lines
740: (
741: p_req_line_id_tbl IN PO_TBL_NUMBER
742: , p_req_line_num_tbl IN PO_TBL_NUMBER
743: , p_po_line_num_tbl IN PO_TBL_NUMBER
744: , p_add_to_po_header_id IN NUMBER
745: , p_builder_agreement_id IN NUMBER
746: , p_builder_supplier_id IN NUMBER

Line 743: , p_po_line_num_tbl IN PO_TBL_NUMBER

739: FUNCTION group_req_lines
740: (
741: p_req_line_id_tbl IN PO_TBL_NUMBER
742: , p_req_line_num_tbl IN PO_TBL_NUMBER
743: , p_po_line_num_tbl IN PO_TBL_NUMBER
744: , p_add_to_po_header_id IN NUMBER
745: , p_builder_agreement_id IN NUMBER
746: , p_builder_supplier_id IN NUMBER
747: , p_builder_site_id IN NUMBER

Line 753: RETURN PO_TBL_NUMBER

749: , p_start_index IN NUMBER
750: , p_end_index IN NUMBER
751: , p_grouping_method IN VARCHAR2
752: )
753: RETURN PO_TBL_NUMBER
754: IS
755: l_start_index NUMBER;
756: l_end_index NUMBER;
757:

Line 759: l_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;

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;
763: d_position NUMBER := 0;

Line 760: x_po_line_num_tbl PO_TBL_NUMBER := PO_TBL_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;
763: d_position NUMBER := 0;
764:

Line 1847: p_req_line_num_tbl IN PO_TBL_NUMBER

1843: --End of Comments
1844: -------------------------------------------------------------------------------
1845: FUNCTION group_by_requisition_line_num
1846: (
1847: p_req_line_num_tbl IN PO_TBL_NUMBER
1848: , p_po_line_num_tbl IN PO_TBL_NUMBER
1849: , p_start_index IN NUMBER
1850: , p_end_index IN NUMBER
1851: )

Line 1848: , p_po_line_num_tbl IN PO_TBL_NUMBER

1844: -------------------------------------------------------------------------------
1845: FUNCTION group_by_requisition_line_num
1846: (
1847: p_req_line_num_tbl IN PO_TBL_NUMBER
1848: , p_po_line_num_tbl IN PO_TBL_NUMBER
1849: , p_start_index IN NUMBER
1850: , p_end_index IN NUMBER
1851: )
1852: RETURN PO_TBL_NUMBER

Line 1852: RETURN PO_TBL_NUMBER

1848: , p_po_line_num_tbl IN PO_TBL_NUMBER
1849: , p_start_index IN NUMBER
1850: , p_end_index IN NUMBER
1851: )
1852: RETURN PO_TBL_NUMBER
1853: IS
1854: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
1855:
1856: TYPE NUM_INDEX_TBL_TYPE IS TABLE OF VARCHAR2(1) INDEX BY PLS_INTEGER;

Line 1854: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;

1850: , p_end_index IN NUMBER
1851: )
1852: RETURN PO_TBL_NUMBER
1853: IS
1854: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
1855:
1856: TYPE NUM_INDEX_TBL_TYPE IS TABLE OF VARCHAR2(1) INDEX BY PLS_INTEGER;
1857: l_line_num_used_tbl NUM_INDEX_TBL_TYPE;
1858:

Line 1951: p_po_line_num_tbl IN PO_TBL_NUMBER

1947: --End of Comments
1948: -------------------------------------------------------------------------------
1949: FUNCTION group_by_requisition_seq_num
1950: (
1951: p_po_line_num_tbl IN PO_TBL_NUMBER
1952: , p_add_to_po_header_id IN NUMBER
1953: , p_start_index IN NUMBER
1954: , p_end_index IN NUMBER
1955: )

Line 1956: RETURN PO_TBL_NUMBER

1952: , p_add_to_po_header_id IN NUMBER
1953: , p_start_index IN NUMBER
1954: , p_end_index IN NUMBER
1955: )
1956: RETURN PO_TBL_NUMBER
1957: IS
1958: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
1959:
1960: l_max_line_num NUMBER;

Line 1958: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;

1954: , p_end_index IN NUMBER
1955: )
1956: RETURN PO_TBL_NUMBER
1957: IS
1958: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
1959:
1960: l_max_line_num NUMBER;
1961: l_next_line_num NUMBER;
1962:

Line 2041: p_req_line_id_tbl IN PO_TBL_NUMBER

2037: --End of Comments
2038: -------------------------------------------------------------------------------
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

Line 2042: , p_po_line_num_tbl IN PO_TBL_NUMBER

2038: -------------------------------------------------------------------------------
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

Line 2049: RETURN PO_TBL_NUMBER

2045: , p_builder_agreement_id IN NUMBER
2046: , p_start_index IN NUMBER
2047: , p_end_index IN NUMBER
2048: )
2049: RETURN PO_TBL_NUMBER
2050: IS
2051: l_max_line_num NUMBER := 0;
2052: l_matching_index NUMBER;
2053: l_po_line_num NUMBER;

Line 2054: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;

2050: IS
2051: l_max_line_num NUMBER := 0;
2052: l_matching_index NUMBER;
2053: l_po_line_num NUMBER;
2054: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
2055:
2056: l_add_to_po_req_line_id_tbl PO_TBL_NUMBER;
2057: l_add_to_po_line_num_tbl PO_TBL_NUMBER;
2058:

Line 2056: l_add_to_po_req_line_id_tbl PO_TBL_NUMBER;

2052: l_matching_index NUMBER;
2053: l_po_line_num NUMBER;
2054: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
2055:
2056: l_add_to_po_req_line_id_tbl PO_TBL_NUMBER;
2057: l_add_to_po_line_num_tbl PO_TBL_NUMBER;
2058:
2059: d_mod CONSTANT VARCHAR2(100) := D_group_by_default;
2060: d_position NUMBER := 0;

Line 2057: l_add_to_po_line_num_tbl PO_TBL_NUMBER;

2053: l_po_line_num NUMBER;
2054: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
2055:
2056: l_add_to_po_req_line_id_tbl PO_TBL_NUMBER;
2057: l_add_to_po_line_num_tbl PO_TBL_NUMBER;
2058:
2059: d_mod CONSTANT VARCHAR2(100) := D_group_by_default;
2060: d_position NUMBER := 0;
2061:

Line 2184: p_req_line_id_tbl IN PO_TBL_NUMBER

2180: --End of Comments
2181: -------------------------------------------------------------------------------
2182: FUNCTION has_same_req_header
2183: (
2184: p_req_line_id_tbl IN PO_TBL_NUMBER
2185: )
2186: RETURN BOOLEAN
2187: IS
2188: l_req_header_id NUMBER;

Line 2284: p_req_line_id_tbl IN PO_TBL_NUMBER

2280: --End of Comments
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

Line 2290: , x_req_line_id_tbl OUT NOCOPY PO_TBL_NUMBER

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
2290: , x_req_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
2291: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER
2292: )
2293: IS
2294: l_key NUMBER;

Line 2291: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER

2287: , p_builder_agreement_id IN NUMBER
2288: , p_start_index IN NUMBER
2289: , p_end_index IN NUMBER
2290: , x_req_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
2291: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER
2292: )
2293: IS
2294: l_key NUMBER;
2295:

Line 2312: x_req_line_id_tbl := PO_TBL_NUMBER();

2308: -- Return immediately if there is no Add To PO.
2309: --
2310: IF ( p_add_to_po_header_id IS NULL )
2311: THEN
2312: x_req_line_id_tbl := PO_TBL_NUMBER();
2313: x_po_line_num_tbl := PO_TBL_NUMBER();
2314: return;
2315: END IF;
2316:

Line 2313: x_po_line_num_tbl := PO_TBL_NUMBER();

2309: --
2310: IF ( p_add_to_po_header_id IS NULL )
2311: THEN
2312: x_req_line_id_tbl := PO_TBL_NUMBER();
2313: x_po_line_num_tbl := PO_TBL_NUMBER();
2314: return;
2315: END IF;
2316:
2317: d_position := 10;

Line 2448: , p_req_line_id_tbl IN PO_TBL_NUMBER

2444: -------------------------------------------------------------------------------
2445: FUNCTION find_matching_builder_line_num
2446: (
2447: p_current_index IN NUMBER
2448: , p_req_line_id_tbl IN PO_TBL_NUMBER
2449: , p_po_line_num_tbl IN PO_TBL_NUMBER
2450: , p_builder_agreement_id IN NUMBER
2451: )
2452: RETURN NUMBER

Line 2449: , p_po_line_num_tbl IN PO_TBL_NUMBER

2445: FUNCTION find_matching_builder_line_num
2446: (
2447: p_current_index IN NUMBER
2448: , p_req_line_id_tbl IN PO_TBL_NUMBER
2449: , p_po_line_num_tbl IN PO_TBL_NUMBER
2450: , p_builder_agreement_id IN NUMBER
2451: )
2452: RETURN NUMBER
2453: IS

Line 2596: p_po_line_num_tbl IN PO_TBL_NUMBER

2592: --End of Comments
2593: -------------------------------------------------------------------------------
2594: FUNCTION get_max_po_line_num
2595: (
2596: p_po_line_num_tbl IN PO_TBL_NUMBER
2597: , p_po_header_id IN NUMBER := NULL
2598: )
2599: RETURN NUMBER
2600: IS

Line 2676: p_req_line_id_tbl IN PO_TBL_NUMBER

2672: --End of Comments
2673: -------------------------------------------------------------------------------
2674: FUNCTION get_consigned_flag_tbl
2675: (
2676: p_req_line_id_tbl IN PO_TBL_NUMBER
2677: , p_builder_org_id IN NUMBER
2678: , p_builder_supplier_id IN NUMBER
2679: , p_builder_site_id IN NUMBER
2680: )

Line 2766: , p_comparison_tbl IN PO_TBL_NUMBER

2762: -------------------------------------------------------------------------------
2763: FUNCTION find_matching_po_line_num
2764: (
2765: p_req_line_id IN NUMBER
2766: , p_comparison_tbl IN PO_TBL_NUMBER
2767: , p_po_line_num_tbl IN PO_TBL_NUMBER
2768: )
2769: RETURN NUMBER
2770: IS

Line 2767: , p_po_line_num_tbl IN PO_TBL_NUMBER

2763: FUNCTION find_matching_po_line_num
2764: (
2765: p_req_line_id IN NUMBER
2766: , p_comparison_tbl IN PO_TBL_NUMBER
2767: , p_po_line_num_tbl IN PO_TBL_NUMBER
2768: )
2769: RETURN NUMBER
2770: IS
2771: d_mod CONSTANT VARCHAR2(100) := D_find_matching_po_line_num;