1 package csi_t_utilities_pvt as
2 /* $Header: csivtuls.pls 120.2 2006/03/16 03:22:27 srsarava noship $ */
3
4 g_pkg_name varchar2(30) := 'csi_t_utilities_pvt';
5
6 TYPE txn_cascade_rec IS RECORD(
7 PARENT_SOURCE_TABLE VARCHAR2(30) := fnd_api.g_miss_char,
8 PARENT_SOURCE_ID NUMBER := fnd_api.g_miss_num,
9 CHILD_SOURCE_ID NUMBER := fnd_api.g_miss_num,
10 ORDERED_QUANTITY NUMBER := fnd_api.g_miss_num, --fix for bug 5096435
11 INVENTORY_ITEM_ID NUMBER := fnd_api.g_miss_num,
12 ITEM_REVISION VARCHAR2(30) := fnd_api.g_miss_char,
13 QUANTITY_RATIO NUMBER := fnd_api.g_miss_num,
14 ITEM_UOM VARCHAR2(3) := fnd_api.g_miss_char);
15
16 TYPE txn_cascade_tbl IS TABLE OF txn_cascade_rec INDEX BY binary_integer;
17
18 PROCEDURE build_instance_id_list(
19 p_txn_line_detial_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
20 x_instance_id_list OUT NOCOPY varchar2,
21 x_return_status OUT NOCOPY varchar2);
22
23 PROCEDURE build_txn_line_id_list(
24 p_txn_line_detial_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
25 x_txn_line_id_list OUT NOCOPY varchar2,
26 x_return_status OUT NOCOPY varchar2);
27
28 PROCEDURE build_party_dtl_id_list(
29 p_txn_party_detial_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
30 x_party_dtl_id_list OUT NOCOPY varchar2,
31 x_return_status OUT NOCOPY varchar2);
32
33 PROCEDURE build_line_dtl_id_list(
34 p_txn_line_detial_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
35 x_line_dtl_id_list OUT NOCOPY varchar2,
36 x_return_status OUT NOCOPY varchar2);
37
38 PROCEDURE build_txn_system_id_list(
39 p_txn_line_detial_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
40 x_txn_system_id_list OUT NOCOPY varchar2,
41 x_return_status OUT NOCOPY varchar2);
42
43 PROCEDURE merge_tables(
44 px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
45 px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
46 px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
47 px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
48 px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
49 px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
50 px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
51 --
52 p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
53 p_pty_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
54 p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
55 p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
56 p_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
57 p_ext_attrib_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
58 p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl);
59
60 PROCEDURE convert_ids_to_index(
61 px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
62 px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
63 px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
64 px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
65 px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
66 px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
67 px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl);
68
69 PROCEDURE get_source_dtls(
70 p_txn_source_param_rec IN csi_t_ui_pvt.txn_source_param_rec,
71 x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
72 x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
73 x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
74 x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
75 x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
76 x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
77 x_return_status OUT NOCOPY varchar2);
78
79 PROCEDURE cascade_child(
80 p_data_string IN varchar2,
81 x_return_status OUT NOCOPY varchar2);
82
83 PROCEDURE cascade_model(
84 p_model_line_id IN number,
85 x_return_status OUT NOCOPY varchar2);
86
87 PROCEDURE cascade(
88 p_txn_cascade_tbl IN csi_t_utilities_pvt.txn_cascade_tbl,
89 x_return_status OUT NOCOPY varchar2);
90
91 END csi_t_utilities_pvt;
92