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 3941: x_item_revision_tbl IN OUT NOCOPY PO_TBL_VARCHAR5

3937: PROCEDURE derive_item_revision
3938: (
3939: p_key IN po_session_gt.key%TYPE,
3940: p_item_id_tbl IN PO_TBL_NUMBER,
3941: x_item_revision_tbl IN OUT NOCOPY PO_TBL_VARCHAR5
3942: ) IS
3943:
3944: d_api_name CONSTANT VARCHAR2(30) := 'derive_item_revision';
3945: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4110: p_file_line_language_tbl IN PO_TBL_VARCHAR5,

4106: PROCEDURE derive_job_id
4107: (
4108: p_key IN po_session_gt.key%TYPE,
4109: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4110: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
4111: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
4112: p_job_name_tbl IN PO_TBL_VARCHAR2000,
4113: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
4114: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 4412: p_file_line_language_tbl IN PO_TBL_VARCHAR5,

4408: PROCEDURE derive_ip_category_id
4409: (
4410: p_key IN po_session_gt.key%TYPE,
4411: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4412: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
4413: p_ip_category_tbl IN PO_TBL_VARCHAR2000,
4414: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4415: ) IS
4416:

Line 4542: p_uom_code_tbl IN PO_TBL_VARCHAR5,

4538: PROCEDURE derive_unit_of_measure
4539: (
4540: p_key IN po_session_gt.key%TYPE,
4541: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4542: p_uom_code_tbl IN PO_TBL_VARCHAR5,
4543: x_unit_of_measure_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
4544: ) IS
4545:
4546: d_api_name CONSTANT VARCHAR2(30) := 'derive_unit_of_measure';

Line 4634: p_file_line_language_tbl IN PO_TBL_VARCHAR5,

4630: PROCEDURE derive_line_type_id
4631: (
4632: p_key IN po_session_gt.key%TYPE,
4633: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4634: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
4635: p_line_type_tbl IN PO_TBL_VARCHAR30,
4636: x_line_type_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4637: ) IS
4638: