APPS.MTL_IC_PARAMETERS_PKG dependencies on MTL_INTERCOMPANY_PARAMETERS

Line 44: SELECT rowid FROM MTL_INTERCOMPANY_PARAMETERS

40: X_Expense_Accrual_Account_Id NUMBER DEFAULT NULL
41: ) IS
42:
43: CURSOR C IS
44: SELECT rowid FROM MTL_INTERCOMPANY_PARAMETERS
45: WHERE ship_organization_id = X_Ship_Organization_Id
46: AND sell_organization_id = X_Sell_Organization_Id
47: AND ( (inv_control.get_current_release_level < inv_release.GET_J_RELEASE_LEVEL)
48: OR

Line 71: INSERT INTO MTL_INTERCOMPANY_PARAMETERS(

67: l_Inventory_Accrual_Account_Id := NULL;
68: l_Expense_Accrual_Account_Id := NULL;
69: END IF;
70:
71: INSERT INTO MTL_INTERCOMPANY_PARAMETERS(
72: ship_organization_id,
73: sell_organization_id,
74: last_update_date,
75: last_updated_by,

Line 197: FROM MTL_INTERCOMPANY_PARAMETERS

193: X_Expense_Accrual_Account_Id NUMBER DEFAULT NULL
194: ) IS
195: CURSOR C IS
196: SELECT *
197: FROM MTL_INTERCOMPANY_PARAMETERS
198: WHERE rowid = X_Rowid
199: FOR UPDATE of Ship_Organization_Id NOWAIT;
200: Recinfo C%ROWTYPE;
201:

Line 357: UPDATE MTL_INTERCOMPANY_PARAMETERS

353: ) IS
354:
355:
356: BEGIN
357: UPDATE MTL_INTERCOMPANY_PARAMETERS
358: SET
359: last_update_date = X_Last_Update_Date,
360: last_updated_by = X_Last_Updated_By,
361: last_update_login = X_Last_Update_Login,

Line 394: UPDATE MTL_INTERCOMPANY_PARAMETERS

390: Raise NO_DATA_FOUND;
391: end if;
392:
393: IF(inv_control.get_current_release_level >= inv_release.GET_J_RELEASE_LEVEL) Then
394: UPDATE MTL_INTERCOMPANY_PARAMETERS
395: SET
396: flow_type = X_Flow_Type,
397: intercompany_cogs_account_id = X_Intercompany_COGS_Account_Id,
398: inventory_Accrual_account_id = X_Inventory_Accrual_Account_Id,

Line 402: UPDATE MTL_INTERCOMPANY_PARAMETERS

398: inventory_Accrual_account_id = X_Inventory_Accrual_Account_Id,
399: expense_Accrual_account_id = X_Expense_Accrual_Account_Id
400: WHERE rowid = X_Rowid;
401: ELSE
402: UPDATE MTL_INTERCOMPANY_PARAMETERS
403: SET
404: flow_type = 1, -- Should be always 1 (Shipping) if INV-J is not installed. Bug# 3271622
405: intercompany_cogs_account_id = NULL,
406: inventory_Accrual_account_id = NULL,

Line 420: DELETE FROM MTL_INTERCOMPANY_PARAMETERS

416:
417: PROCEDURE Delete_Row(X_Ship_Organization_Id NUMBER,
418: X_Sell_Organization_Id NUMBER) IS
419: BEGIN
420: DELETE FROM MTL_INTERCOMPANY_PARAMETERS
421: WHERE ship_organization_id=X_Ship_Organization_Id
422: AND sell_organization_id=X_Sell_Organization_Id;
423:
424: if (SQL%NOTFOUND) then