DBA Data[Home] [Help]

APPS.CSE_PO_RECEIPT_INTO_PROJECT dependencies on CSI_DATASTRUCTURES_PUB

Line 90: l_instance_rec csi_datastructures_pub.Instance_Rec;

86: x_return_status OUT NOCOPY varchar2,
87: x_error_message OUT NOCOPY varchar2)
88: IS
89: l_rcv_transaction_id NUMBER;
90: l_instance_rec csi_datastructures_pub.Instance_Rec;
91: l_instance_query_rec csi_datastructures_pub.Instance_Query_Rec;
92: l_api_version NUMBER DEFAULT 1.0;
93: l_commit varchar2(1) DEFAULT FND_API.G_FALSE;
94: l_init_msg_list varchar2(1) DEFAULT FND_API.G_TRUE;

Line 91: l_instance_query_rec csi_datastructures_pub.Instance_Query_Rec;

87: x_error_message OUT NOCOPY varchar2)
88: IS
89: l_rcv_transaction_id NUMBER;
90: l_instance_rec csi_datastructures_pub.Instance_Rec;
91: l_instance_query_rec csi_datastructures_pub.Instance_Query_Rec;
92: l_api_version NUMBER DEFAULT 1.0;
93: l_commit varchar2(1) DEFAULT FND_API.G_FALSE;
94: l_init_msg_list varchar2(1) DEFAULT FND_API.G_TRUE;
95: l_active_instance_only varchar2(1) DEFAULT FND_API.G_FALSE;

Line 100: l_instance_header_tbl_out csi_datastructures_pub.instance_header_tbl;

96: l_resolve_id_columns varchar2(1) DEFAULT FND_API.G_FALSE;
97: l_time_stamp varchar2(50);
98: l_object_version_number NUMBER := 1;
99: l_sysdate DATE := SYSDATE;
100: l_instance_header_tbl_out csi_datastructures_pub.instance_header_tbl;
101: l_error_message varchar2(2000);
102: l_return_status varchar2(1);
103: l_msg_count NUMBER;
104: l_msg_data varchar2(2000);

Line 105: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;

101: l_error_message varchar2(2000);
102: l_return_status varchar2(1);
103: l_msg_count NUMBER;
104: l_msg_data varchar2(2000);
105: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
106: l_Account_Query_Rec csi_datastructures_pub.party_account_query_rec;
107: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;
108: l_Is_Item_Serialized varchar2(2);
109: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 106: l_Account_Query_Rec csi_datastructures_pub.party_account_query_rec;

102: l_return_status varchar2(1);
103: l_msg_count NUMBER;
104: l_msg_data varchar2(2000);
105: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
106: l_Account_Query_Rec csi_datastructures_pub.party_account_query_rec;
107: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;
108: l_Is_Item_Serialized varchar2(2);
109: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
110: l_party_tbl csi_datastructures_pub.party_tbl;

Line 109: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

105: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
106: l_Account_Query_Rec csi_datastructures_pub.party_account_query_rec;
107: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;
108: l_Is_Item_Serialized varchar2(2);
109: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
110: l_party_tbl csi_datastructures_pub.party_tbl;
111: l_account_tbl csi_datastructures_pub.party_account_tbl;
112: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
113: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

Line 110: l_party_tbl csi_datastructures_pub.party_tbl;

106: l_Account_Query_Rec csi_datastructures_pub.party_account_query_rec;
107: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;
108: l_Is_Item_Serialized varchar2(2);
109: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
110: l_party_tbl csi_datastructures_pub.party_tbl;
111: l_account_tbl csi_datastructures_pub.party_account_tbl;
112: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
113: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
114: l_txn_rec csi_datastructures_pub.transaction_rec;

Line 111: l_account_tbl csi_datastructures_pub.party_account_tbl;

107: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;
108: l_Is_Item_Serialized varchar2(2);
109: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
110: l_party_tbl csi_datastructures_pub.party_tbl;
111: l_account_tbl csi_datastructures_pub.party_account_tbl;
112: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
113: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
114: l_txn_rec csi_datastructures_pub.transaction_rec;
115: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

Line 112: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

108: l_Is_Item_Serialized varchar2(2);
109: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
110: l_party_tbl csi_datastructures_pub.party_tbl;
111: l_account_tbl csi_datastructures_pub.party_account_tbl;
112: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
113: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
114: l_txn_rec csi_datastructures_pub.transaction_rec;
115: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
116: l_Transaction_Id NUMBER;

Line 113: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

109: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
110: l_party_tbl csi_datastructures_pub.party_tbl;
111: l_account_tbl csi_datastructures_pub.party_account_tbl;
112: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
113: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
114: l_txn_rec csi_datastructures_pub.transaction_rec;
115: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
116: l_Transaction_Id NUMBER;
117: l_Instance_Id_Lst csi_datastructures_pub.Id_Tbl;

Line 114: l_txn_rec csi_datastructures_pub.transaction_rec;

110: l_party_tbl csi_datastructures_pub.party_tbl;
111: l_account_tbl csi_datastructures_pub.party_account_tbl;
112: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
113: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
114: l_txn_rec csi_datastructures_pub.transaction_rec;
115: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
116: l_Transaction_Id NUMBER;
117: l_Instance_Id_Lst csi_datastructures_pub.Id_Tbl;
118: l_employee_id NUMBER;

Line 115: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;

111: l_account_tbl csi_datastructures_pub.party_account_tbl;
112: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
113: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
114: l_txn_rec csi_datastructures_pub.transaction_rec;
115: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
116: l_Transaction_Id NUMBER;
117: l_Instance_Id_Lst csi_datastructures_pub.Id_Tbl;
118: l_employee_id NUMBER;
119: l_Depreciable varchar2(3);

Line 117: l_Instance_Id_Lst csi_datastructures_pub.Id_Tbl;

113: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
114: l_txn_rec csi_datastructures_pub.transaction_rec;
115: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
116: l_Transaction_Id NUMBER;
117: l_Instance_Id_Lst csi_datastructures_pub.Id_Tbl;
118: l_employee_id NUMBER;
119: l_Depreciable varchar2(3);
120: l_Transaction_Status_Code varchar2(30);
121: l_Location_Id NUMBER;