DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PO_TBL_VARCHAR5

Line 33: x_item_revision_tbl IN OUT NOCOPY PO_TBL_VARCHAR5

29: PROCEDURE derive_item_revision
30: (
31: p_key IN po_session_gt.key%TYPE,
32: p_item_id_tbl IN PO_TBL_NUMBER,
33: x_item_revision_tbl IN OUT NOCOPY PO_TBL_VARCHAR5
34: );
35:
36: PROCEDURE derive_job_business_group_id
37: (

Line 48: p_file_line_language_tbl IN PO_TBL_VARCHAR5,

44: PROCEDURE derive_job_id
45: (
46: p_key IN po_session_gt.key%TYPE,
47: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
48: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
49: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
50: p_job_name_tbl IN PO_TBL_VARCHAR2000,
51: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
52: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 66: p_file_line_language_tbl IN PO_TBL_VARCHAR5,

62: PROCEDURE derive_ip_category_id
63: (
64: p_key IN po_session_gt.key%TYPE,
65: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
66: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
67: p_ip_category_tbl IN PO_TBL_VARCHAR2000,
68: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
69: );
70:

Line 75: p_uom_code_tbl IN PO_TBL_VARCHAR5,

71: PROCEDURE derive_unit_of_measure
72: (
73: p_key IN po_session_gt.key%TYPE,
74: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
75: p_uom_code_tbl IN PO_TBL_VARCHAR5,
76: x_unit_of_measure_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
77: );
78:
79: PROCEDURE derive_line_type_id

Line 83: p_file_line_language_tbl IN PO_TBL_VARCHAR5,

79: PROCEDURE derive_line_type_id
80: (
81: p_key IN po_session_gt.key%TYPE,
82: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
83: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
84: p_line_type_tbl IN PO_TBL_VARCHAR30,
85: x_line_type_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
86: );
87:

Line 4863: x_item_revision_tbl IN OUT NOCOPY PO_TBL_VARCHAR5

4859: PROCEDURE derive_item_revision
4860: (
4861: p_key IN po_session_gt.key%TYPE,
4862: p_item_id_tbl IN PO_TBL_NUMBER,
4863: x_item_revision_tbl IN OUT NOCOPY PO_TBL_VARCHAR5
4864: ) IS
4865:
4866: d_api_name CONSTANT VARCHAR2(30) := 'derive_item_revision';
4867: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5032: p_file_line_language_tbl IN PO_TBL_VARCHAR5,

5028: PROCEDURE derive_job_id
5029: (
5030: p_key IN po_session_gt.key%TYPE,
5031: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5032: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
5033: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
5034: p_job_name_tbl IN PO_TBL_VARCHAR2000,
5035: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
5036: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 5334: p_file_line_language_tbl IN PO_TBL_VARCHAR5,

5330: PROCEDURE derive_ip_category_id
5331: (
5332: p_key IN po_session_gt.key%TYPE,
5333: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5334: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
5335: p_ip_category_tbl IN PO_TBL_VARCHAR2000,
5336: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5337: ) IS
5338:

Line 5464: p_uom_code_tbl IN PO_TBL_VARCHAR5,

5460: PROCEDURE derive_unit_of_measure
5461: (
5462: p_key IN po_session_gt.key%TYPE,
5463: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5464: p_uom_code_tbl IN PO_TBL_VARCHAR5,
5465: x_unit_of_measure_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
5466: ) IS
5467:
5468: d_api_name CONSTANT VARCHAR2(30) := 'derive_unit_of_measure';

Line 5556: p_file_line_language_tbl IN PO_TBL_VARCHAR5,

5552: PROCEDURE derive_line_type_id
5553: (
5554: p_key IN po_session_gt.key%TYPE,
5555: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5556: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
5557: p_line_type_tbl IN PO_TBL_VARCHAR30,
5558: x_line_type_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5559: ) IS
5560: