DBA Data[Home] [Help]

APPS.PO_PDOI_HEADER_PROCESS_PVT dependencies on PO_TBL_VARCHAR2000

Line 23: p_agent_name_tbl IN PO_TBL_VARCHAR2000,

19: PROCEDURE derive_agent_id
20: (
21: p_key IN po_session_gt.key%TYPE,
22: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
23: p_agent_name_tbl IN PO_TBL_VARCHAR2000,
24: x_agent_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
25: );
26:
27: PROCEDURE derive_vendor_site_id

Line 41: p_vendor_contact_tbl IN PO_TBL_VARCHAR2000,

37: (
38: p_key IN po_session_gt.key%TYPE,
39: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
40: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
41: p_vendor_contact_tbl IN PO_TBL_VARCHAR2000,
42: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
43: );
44:
45: PROCEDURE derive_from_header_id

Line 57: p_style_display_name_tbl IN PO_TBL_VARCHAR2000,

53: PROCEDURE derive_style_id
54: (
55: p_key IN po_session_gt.key%TYPE,
56: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
57: p_style_display_name_tbl IN PO_TBL_VARCHAR2000,
58: x_style_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
59: );
60:
61: PROCEDURE default_info_from_vendor

Line 1540: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

1536:
1537: l_headers PO_HEADERS_VAL_TYPE := PO_HEADERS_VAL_TYPE();
1538: l_result_type VARCHAR2(30);
1539: l_results po_validation_results_type;
1540: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
1541: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
1542:
1543: BEGIN
1544: d_position := 0;

Line 1541: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

1537: l_headers PO_HEADERS_VAL_TYPE := PO_HEADERS_VAL_TYPE();
1538: l_result_type VARCHAR2(30);
1539: l_results po_validation_results_type;
1540: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
1541: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
1542:
1543: BEGIN
1544: d_position := 0;
1545:

Line 1910: p_vendor_name_tbl IN PO_TBL_VARCHAR2000,

1906: PROCEDURE derive_vendor_id
1907: (
1908: p_key IN po_session_gt.key%TYPE,
1909: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1910: p_vendor_name_tbl IN PO_TBL_VARCHAR2000,
1911: p_vendor_num_tbl IN PO_TBL_VARCHAR30,
1912: x_vendor_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
1913: ) IS
1914:

Line 2113: p_agent_name_tbl IN PO_TBL_VARCHAR2000,

2109: PROCEDURE derive_agent_id
2110: (
2111: p_key IN po_session_gt.key%TYPE,
2112: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2113: p_agent_name_tbl IN PO_TBL_VARCHAR2000,
2114: x_agent_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2115: ) IS
2116:
2117: d_api_name CONSTANT VARCHAR2(30) := 'derive_agent_id';

Line 2305: p_vendor_contact_tbl IN PO_TBL_VARCHAR2000,

2301: (
2302: p_key IN po_session_gt.key%TYPE,
2303: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2304: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
2305: p_vendor_contact_tbl IN PO_TBL_VARCHAR2000,
2306: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2307: ) IS
2308:
2309: d_api_name CONSTANT VARCHAR2(30) := 'derive_vendor_contact_id';

Line 2403: p_style_display_name_tbl IN PO_TBL_VARCHAR2000,

2399: PROCEDURE derive_style_id
2400: (
2401: p_key IN po_session_gt.key%TYPE,
2402: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2403: p_style_display_name_tbl IN PO_TBL_VARCHAR2000,
2404: x_style_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2405: ) IS
2406:
2407: d_api_name CONSTANT VARCHAR2(30) := 'derive_style_id';