44: x_Return_Status OUT NOCOPY VARCHAR2,
45: x_Error_Message OUT NOCOPY VARCHAR2);
46:
47: PROCEDURE get_destination_instance(
48: P_Dest_Instance_tbl IN csi_datastructures_pub.instance_header_tbl,
49: X_Instance_Rec OUT NOCOPY csi_datastructures_pub.Instance_Rec,
50: X_Return_Status OUT NOCOPY VARCHAR2,
51: x_Error_Message OUT NOCOPY VARCHAR2);
52:
45: x_Error_Message OUT NOCOPY VARCHAR2);
46:
47: PROCEDURE get_destination_instance(
48: P_Dest_Instance_tbl IN csi_datastructures_pub.instance_header_tbl,
49: X_Instance_Rec OUT NOCOPY csi_datastructures_pub.Instance_Rec,
50: X_Return_Status OUT NOCOPY VARCHAR2,
51: x_Error_Message OUT NOCOPY VARCHAR2);
52:
53: PROCEDURE get_master_organization(p_organization_id IN NUMBER,
97: FUNCTION Get_Default_Status_Id(p_transaction_id IN NUMBER) RETURN NUMBER;
98:
99: --PRAGMA RESTRICT_REFERENCES(get_default_status_id, WNDS);
100:
101: FUNCTION Init_Instance_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Query_Rec;
102: FUNCTION Init_Instance_Create_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec;
103:
104: FUNCTION Init_Instance_Update_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec;
105:
98:
99: --PRAGMA RESTRICT_REFERENCES(get_default_status_id, WNDS);
100:
101: FUNCTION Init_Instance_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Query_Rec;
102: FUNCTION Init_Instance_Create_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec;
103:
104: FUNCTION Init_Instance_Update_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec;
105:
106: FUNCTION Init_Txn_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec;
100:
101: FUNCTION Init_Instance_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Query_Rec;
102: FUNCTION Init_Instance_Create_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec;
103:
104: FUNCTION Init_Instance_Update_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec;
105:
106: FUNCTION Init_Txn_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec;
107:
108: FUNCTION Init_Txn_Error_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
102: FUNCTION Init_Instance_Create_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec;
103:
104: FUNCTION Init_Instance_Update_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec;
105:
106: FUNCTION Init_Txn_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec;
107:
108: FUNCTION Init_Txn_Error_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
109:
110: FUNCTION Init_Party_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Tbl;
104: FUNCTION Init_Instance_Update_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec;
105:
106: FUNCTION Init_Txn_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec;
107:
108: FUNCTION Init_Txn_Error_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
109:
110: FUNCTION Init_Party_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Tbl;
111:
112: FUNCTION Init_Account_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
106: FUNCTION Init_Txn_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec;
107:
108: FUNCTION Init_Txn_Error_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
109:
110: FUNCTION Init_Party_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Tbl;
111:
112: FUNCTION Init_Account_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
113:
114: FUNCTION Init_ext_attrib_values_tbl RETURN CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
108: FUNCTION Init_Txn_Error_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
109:
110: FUNCTION Init_Party_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Tbl;
111:
112: FUNCTION Init_Account_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
113:
114: FUNCTION Init_ext_attrib_values_tbl RETURN CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
115:
116: FUNCTION Init_Pricing_Attribs_Tbl RETURN CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
110: FUNCTION Init_Party_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Tbl;
111:
112: FUNCTION Init_Account_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
113:
114: FUNCTION Init_ext_attrib_values_tbl RETURN CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
115:
116: FUNCTION Init_Pricing_Attribs_Tbl RETURN CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
117:
118: FUNCTION Init_Org_Assignments_Tbl RETURN CSI_DATASTRUCTURES_PUB.organization_units_tbl;
112: FUNCTION Init_Account_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
113:
114: FUNCTION Init_ext_attrib_values_tbl RETURN CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
115:
116: FUNCTION Init_Pricing_Attribs_Tbl RETURN CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
117:
118: FUNCTION Init_Org_Assignments_Tbl RETURN CSI_DATASTRUCTURES_PUB.organization_units_tbl;
119:
120: FUNCTION Init_Asset_Assignment_Tbl RETURN CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
114: FUNCTION Init_ext_attrib_values_tbl RETURN CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
115:
116: FUNCTION Init_Pricing_Attribs_Tbl RETURN CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
117:
118: FUNCTION Init_Org_Assignments_Tbl RETURN CSI_DATASTRUCTURES_PUB.organization_units_tbl;
119:
120: FUNCTION Init_Asset_Assignment_Tbl RETURN CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
121:
122: FUNCTION Get_Dflt_Project_Location_Id RETURN NUMBER;
116: FUNCTION Init_Pricing_Attribs_Tbl RETURN CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
117:
118: FUNCTION Init_Org_Assignments_Tbl RETURN CSI_DATASTRUCTURES_PUB.organization_units_tbl;
119:
120: FUNCTION Init_Asset_Assignment_Tbl RETURN CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
121:
122: FUNCTION Get_Dflt_Project_Location_Id RETURN NUMBER;
123:
124: FUNCTION Get_Location_Type_Code(P_Location_Meaning IN VARCHAR2) RETURN VARCHAR2;
138: FUNCTION Get_Txn_Action_Code(P_Txn_Action IN VARCHAR2) RETURN VARCHAR2;
139:
140: FUNCTION Get_Fnd_Employee_Id(P_Last_Updated IN NUMBER) RETURN NUMBER;
141:
142: FUNCTION Init_Instance_Asset_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec;
143:
144: FUNCTION Init_Instance_Asset_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Rec;
145:
146: FUNCTION Init_Party_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Party_Query_Rec;
140: FUNCTION Get_Fnd_Employee_Id(P_Last_Updated IN NUMBER) RETURN NUMBER;
141:
142: FUNCTION Init_Instance_Asset_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec;
143:
144: FUNCTION Init_Instance_Asset_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Rec;
145:
146: FUNCTION Init_Party_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Party_Query_Rec;
147:
148: FUNCTION IS_Conc_Prg_Running(P_Request_Id IN NUMBER,P_Executable IN VARCHAR2) RETURN BOOLEAN;
142: FUNCTION Init_Instance_Asset_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec;
143:
144: FUNCTION Init_Instance_Asset_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Rec;
145:
146: FUNCTION Init_Party_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Party_Query_Rec;
147:
148: FUNCTION IS_Conc_Prg_Running(P_Request_Id IN NUMBER,P_Executable IN VARCHAR2) RETURN BOOLEAN;
149:
150: PROCEDURE Write_Log(P_Message IN VARCHAR2);
178: PROCEDURE get_inst_n_comp_dtls(
179: p_instance_id IN NUMBER
180: ,p_transaction_id IN NUMBER
181: ,p_transaction_date IN DATE
182: ,x_inst_dtls_tbl OUT NOCOPY csi_datastructures_pub.instance_header_tbl
183: ,x_return_status OUT NOCOPY VARCHAR2
184: ,x_error_message OUT NOCOPY VARCHAR2) ;
185: -------------------------------------------------------------------------------------
186: