DBA Data[Home] [Help]

APPS.CSE_IN_SERVICE_PKG dependencies on CSI_DATASTRUCTURES_PUB

Line 73: l_Instance_Header_Tbl_Out csi_datastructures_pub.instance_header_tbl;

69: l_api_version NUMBER DEFAULT 1.0;
70: l_Commit VARCHAR2(1);
71: l_Init_Msg_List VARCHAR2(1);
72: l_Create_Dest_Inst_Flag VARCHAR2(1);
73: l_Instance_Header_Tbl_Out csi_datastructures_pub.instance_header_tbl;
74: l_Instance_Rec csi_datastructures_pub.Instance_Rec;
75: l_Dest_Instance_Rec csi_datastructures_pub.Instance_Rec;
76: l_s_last_vld_organization_id NUMBER;
77: l_Instance_Query_Rec csi_datastructures_pub.Instance_Query_Rec;

Line 74: l_Instance_Rec csi_datastructures_pub.Instance_Rec;

70: l_Commit VARCHAR2(1);
71: l_Init_Msg_List VARCHAR2(1);
72: l_Create_Dest_Inst_Flag VARCHAR2(1);
73: l_Instance_Header_Tbl_Out csi_datastructures_pub.instance_header_tbl;
74: l_Instance_Rec csi_datastructures_pub.Instance_Rec;
75: l_Dest_Instance_Rec csi_datastructures_pub.Instance_Rec;
76: l_s_last_vld_organization_id NUMBER;
77: l_Instance_Query_Rec csi_datastructures_pub.Instance_Query_Rec;
78: l_App_Short_Name CONSTANT VARCHAR2(10):='CSE';

Line 75: l_Dest_Instance_Rec csi_datastructures_pub.Instance_Rec;

71: l_Init_Msg_List VARCHAR2(1);
72: l_Create_Dest_Inst_Flag VARCHAR2(1);
73: l_Instance_Header_Tbl_Out csi_datastructures_pub.instance_header_tbl;
74: l_Instance_Rec csi_datastructures_pub.Instance_Rec;
75: l_Dest_Instance_Rec csi_datastructures_pub.Instance_Rec;
76: l_s_last_vld_organization_id NUMBER;
77: l_Instance_Query_Rec csi_datastructures_pub.Instance_Query_Rec;
78: l_App_Short_Name CONSTANT VARCHAR2(10):='CSE';
79: l_txn_rec csi_datastructures_pub.transaction_rec;

Line 77: l_Instance_Query_Rec csi_datastructures_pub.Instance_Query_Rec;

73: l_Instance_Header_Tbl_Out csi_datastructures_pub.instance_header_tbl;
74: l_Instance_Rec csi_datastructures_pub.Instance_Rec;
75: l_Dest_Instance_Rec csi_datastructures_pub.Instance_Rec;
76: l_s_last_vld_organization_id NUMBER;
77: l_Instance_Query_Rec csi_datastructures_pub.Instance_Query_Rec;
78: l_App_Short_Name CONSTANT VARCHAR2(10):='CSE';
79: l_txn_rec csi_datastructures_pub.transaction_rec;
80: l_sysdate DATE:=sysdate;
81: l_upd_txn_rec csi_datastructures_pub.transaction_rec;

Line 79: l_txn_rec csi_datastructures_pub.transaction_rec;

75: l_Dest_Instance_Rec csi_datastructures_pub.Instance_Rec;
76: l_s_last_vld_organization_id NUMBER;
77: l_Instance_Query_Rec csi_datastructures_pub.Instance_Query_Rec;
78: l_App_Short_Name CONSTANT VARCHAR2(10):='CSE';
79: l_txn_rec csi_datastructures_pub.transaction_rec;
80: l_sysdate DATE:=sysdate;
81: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
82: l_transaction_type_id NUMBER;
83: l_Active_Instance_Only VARCHAR2(1);

Line 81: l_upd_txn_rec csi_datastructures_pub.transaction_rec;

77: l_Instance_Query_Rec csi_datastructures_pub.Instance_Query_Rec;
78: l_App_Short_Name CONSTANT VARCHAR2(10):='CSE';
79: l_txn_rec csi_datastructures_pub.transaction_rec;
80: l_sysdate DATE:=sysdate;
81: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
82: l_transaction_type_id NUMBER;
83: l_Active_Instance_Only VARCHAR2(1);
84: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
85: l_Resolve_Id_Columns VARCHAR2(1);

Line 84: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

80: l_sysdate DATE:=sysdate;
81: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
82: l_transaction_type_id NUMBER;
83: l_Active_Instance_Only VARCHAR2(1);
84: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
85: l_Resolve_Id_Columns VARCHAR2(1);
86: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
87: l_party_tbl csi_datastructures_pub.party_tbl;
88: l_account_tbl csi_datastructures_pub.party_account_tbl;

Line 86: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;

82: l_transaction_type_id NUMBER;
83: l_Active_Instance_Only VARCHAR2(1);
84: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
85: l_Resolve_Id_Columns VARCHAR2(1);
86: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
87: l_party_tbl csi_datastructures_pub.party_tbl;
88: l_account_tbl csi_datastructures_pub.party_account_tbl;
89: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
90: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 87: l_party_tbl csi_datastructures_pub.party_tbl;

83: l_Active_Instance_Only VARCHAR2(1);
84: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
85: l_Resolve_Id_Columns VARCHAR2(1);
86: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
87: l_party_tbl csi_datastructures_pub.party_tbl;
88: l_account_tbl csi_datastructures_pub.party_account_tbl;
89: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
90: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
91: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 88: l_account_tbl csi_datastructures_pub.party_account_tbl;

84: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
85: l_Resolve_Id_Columns VARCHAR2(1);
86: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
87: l_party_tbl csi_datastructures_pub.party_tbl;
88: l_account_tbl csi_datastructures_pub.party_account_tbl;
89: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
90: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
91: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
92: l_Instance_Id_Lst csi_datastructures_pub.Id_Tbl;

Line 89: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

85: l_Resolve_Id_Columns VARCHAR2(1);
86: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
87: l_party_tbl csi_datastructures_pub.party_tbl;
88: l_account_tbl csi_datastructures_pub.party_account_tbl;
89: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
90: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
91: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
92: l_Instance_Id_Lst csi_datastructures_pub.Id_Tbl;
93: l_msg_index NUMBER;

Line 90: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

86: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
87: l_party_tbl csi_datastructures_pub.party_tbl;
88: l_account_tbl csi_datastructures_pub.party_account_tbl;
89: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
90: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
91: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
92: l_Instance_Id_Lst csi_datastructures_pub.Id_Tbl;
93: l_msg_index NUMBER;
94: i PLS_INTEGER;

Line 91: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

87: l_party_tbl csi_datastructures_pub.party_tbl;
88: l_account_tbl csi_datastructures_pub.party_account_tbl;
89: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
90: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
91: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
92: l_Instance_Id_Lst csi_datastructures_pub.Id_Tbl;
93: l_msg_index NUMBER;
94: i PLS_INTEGER;
95: l_S_object_version_number NUMBER :=1;

Line 92: l_Instance_Id_Lst csi_datastructures_pub.Id_Tbl;

88: l_account_tbl csi_datastructures_pub.party_account_tbl;
89: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
90: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
91: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
92: l_Instance_Id_Lst csi_datastructures_pub.Id_Tbl;
93: l_msg_index NUMBER;
94: i PLS_INTEGER;
95: l_S_object_version_number NUMBER :=1;
96: l_D_object_version_number NUMBER :=1;

Line 100: l_Account_Query_Rec csi_datastructures_pub.party_account_query_rec;

96: l_D_object_version_number NUMBER :=1;
97: l_object_version_number NUMBER :=1;
98: l_Msg_Count NUMBER;
99: l_Msg_Data VARCHAR2(2000);
100: l_Account_Query_Rec csi_datastructures_pub.party_account_query_rec;
101: l_Validation_Level NUMBER;
102: l_Transaction_Id NUMBER;
103: l_Resolve_Id_Column VARCHAR2(1);
104: l_Return_Status VARCHAR2(1);