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 113: x_clm_standard_form_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000,

109: p_key IN po_session_gt.key%TYPE,
110: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
111: p_style_id_tbl IN PO_TBL_NUMBER,
112: p_clm_award_type IN PO_TBL_VARCHAR30,
113: x_clm_standard_form_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000,
114: x_clm_document_format_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000
115: );
116:
117: PROCEDURE derive_clm_award_type

Line 114: x_clm_document_format_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000

110: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
111: p_style_id_tbl IN PO_TBL_NUMBER,
112: p_clm_award_type IN PO_TBL_VARCHAR30,
113: x_clm_standard_form_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000,
114: x_clm_document_format_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000
115: );
116:
117: PROCEDURE derive_clm_award_type
118: (

Line 130: x_clm_award_administrator_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000

126: (
127: p_key IN po_session_gt.key%TYPE,
128: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
129: p_clm_award_admin_disp_tbl IN PO_TBL_VARCHAR240,
130: x_clm_award_administrator_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000
131: );
132:
133: PROCEDURE derive_clm_contract_officer
134: (

Line 2038: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

2034:
2035: l_headers PO_HEADERS_VAL_TYPE := PO_HEADERS_VAL_TYPE();
2036: l_result_type VARCHAR2(30);
2037: l_results po_validation_results_type;
2038: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
2039: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
2040:
2041: BEGIN
2042: d_position := 0;

Line 2039: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

2035: l_headers PO_HEADERS_VAL_TYPE := PO_HEADERS_VAL_TYPE();
2036: l_result_type VARCHAR2(30);
2037: l_results po_validation_results_type;
2038: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
2039: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
2040:
2041: BEGIN
2042: d_position := 0;
2043:

Line 2419: p_vendor_name_tbl IN PO_TBL_VARCHAR2000,

2415: PROCEDURE derive_vendor_id
2416: (
2417: p_key IN po_session_gt.key%TYPE,
2418: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2419: p_vendor_name_tbl IN PO_TBL_VARCHAR2000,
2420: p_vendor_num_tbl IN PO_TBL_VARCHAR30,
2421: x_vendor_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2422: ) IS
2423:

Line 2622: p_agent_name_tbl IN PO_TBL_VARCHAR2000,

2618: PROCEDURE derive_agent_id
2619: (
2620: p_key IN po_session_gt.key%TYPE,
2621: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2622: p_agent_name_tbl IN PO_TBL_VARCHAR2000,
2623: x_agent_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2624: ) IS
2625:
2626: d_api_name CONSTANT VARCHAR2(30) := 'derive_agent_id';

Line 2814: p_vendor_contact_tbl IN PO_TBL_VARCHAR2000,

2810: (
2811: p_key IN po_session_gt.key%TYPE,
2812: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2813: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
2814: p_vendor_contact_tbl IN PO_TBL_VARCHAR2000,
2815: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2816: ) IS
2817:
2818: d_api_name CONSTANT VARCHAR2(30) := 'derive_vendor_contact_id';

Line 2912: p_style_display_name_tbl IN PO_TBL_VARCHAR2000,

2908: PROCEDURE derive_style_id
2909: (
2910: p_key IN po_session_gt.key%TYPE,
2911: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2912: p_style_display_name_tbl IN PO_TBL_VARCHAR2000,
2913: x_style_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2914: ) IS
2915:
2916: d_api_name CONSTANT VARCHAR2(30) := 'derive_style_id';

Line 3735: x_clm_standard_form_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000,

3731: p_key IN po_session_gt.key%TYPE,
3732: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3733: p_style_id_tbl IN PO_TBL_NUMBER,
3734: p_clm_award_type IN PO_TBL_VARCHAR30,
3735: x_clm_standard_form_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000,
3736: x_clm_document_format_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000
3737: ) IS
3738:
3739: d_api_name CONSTANT VARCHAR2(30) := 'deafult_clm_standard_format';

Line 3736: x_clm_document_format_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000

3732: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3733: p_style_id_tbl IN PO_TBL_NUMBER,
3734: p_clm_award_type IN PO_TBL_VARCHAR30,
3735: x_clm_standard_form_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000,
3736: x_clm_document_format_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000
3737: ) IS
3738:
3739: d_api_name CONSTANT VARCHAR2(30) := 'deafult_clm_standard_format';
3740: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3949: x_clm_award_administrator_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000

3945: (
3946: p_key IN po_session_gt.key%TYPE,
3947: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3948: p_clm_award_admin_disp_tbl IN PO_TBL_VARCHAR240,
3949: x_clm_award_administrator_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000
3950: ) IS
3951:
3952: d_api_name CONSTANT VARCHAR2(30) := 'derive_clm_award_admin';
3953: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';