DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on OKX_CUSTOMER_ACCOUNTS_V

Line 8180: FROM Okx_Customer_Accounts_V CA

8176: IS
8177:
8178: CURSOR Lx_Csr_CovCust(Cx_CovCust_Id IN Gx_OKS_Id) IS
8179: SELECT CA.Party_Id
8180: FROM Okx_Customer_Accounts_V CA
8181: WHERE CA.Id1 = Cx_CovCust_Id
8182: AND CA.Id2 = '#';
8183:
8184: Lx_CovCust_Obj_Id CONSTANT Gx_OKS_Id := P_CovCust_Obj_Id;

Line 8193: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;

8189:
8190: Lx_Result Gx_Boolean;
8191: Lx_Return_Status Gx_Ret_Sts;
8192:
8193: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
8194:
8195: Li_TableIdx BINARY_INTEGER;
8196: L_EXCEP_UNEXPECTED_ERR EXCEPTION;
8197: L_EXCEP_NO_DATA_FOUND EXCEPTION;

Line 8321: Lx_Party_Id_Dummy Okx_Customer_Accounts_V.Party_Id%TYPE;

8317: Lx_Return_Status Gx_Ret_Sts;
8318:
8319: Lx_Cust_Account_Id Okx_Cust_Site_Uses_V.Cust_Account_Id%TYPE;
8320: Lx_Party_Id Okx_Cust_Site_Uses_V.Party_Id%TYPE;
8321: Lx_Party_Id_Dummy Okx_Customer_Accounts_V.Party_Id%TYPE;
8322:
8323: Li_TableIdx BINARY_INTEGER;
8324:
8325: L_EXCEP_UNEXPECTED_ERR EXCEPTION;

Line 8447: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;

8443:
8444: Lx_System_Customer GT_ContItem_Ref;
8445: Lx_System_Site GT_ContItem_Ref;
8446:
8447: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
8448:
8449: Lx_Result Gx_Boolean;
8450: Lx_Return_Status Gx_Ret_Sts;
8451:

Line 8741: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;

8737: Lx_Customer_Id Okx_Customer_Products_V.Customer_Id%TYPE;
8738: Lx_Site_Id Okx_Customer_Products_V.Install_Site_Use_Id%TYPE;
8739: */
8740:
8741: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
8742: Lx_Inv_Item_Id CSI_ITEM_INSTANCES.Inventory_Item_Id%TYPE;
8743: Lx_System_Id CSI_ITEM_INSTANCES.System_Id%TYPE;
8744: Lx_Customer_Id CSI_ITEM_INSTANCES.Owner_Party_Id%TYPE;
8745: Lx_Site_Id CSI_ITEM_INSTANCES.Install_location_id%TYPE;

Line 9432: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;

9428: Lx_CovProd_Obj_Id CONSTANT Gx_OKS_Id := P_CovProd_Obj_Id;
9429: Ln_Organization_Id CONSTANT NUMBER := P_Organization_Id;
9430: Ln_Org_Id CONSTANT NUMBER := P_Org_Id;
9431:
9432: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
9433:
9434: Lx_Product_CovLevels GT_ContItem_Ref;
9435: Lx_CovProd_Contracts GT_Contract_Ref;
9436:

Line 9767: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;

9763:
9764: Lx_Cust_CovLevels GT_ContItem_Ref;
9765: Lx_CovCust_Contracts GT_Contract_Ref;
9766:
9767: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
9768:
9769: Lx_Result Gx_Boolean;
9770: Lx_Return_Status Gx_Ret_Sts;
9771:

Line 18368: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;

18364: l_contract_line_id NUMBER;
18365: l_busiproc_match VARCHAR2(1);
18366: j NUMBER ;
18367:
18368: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
18369: Lx_Product_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18370: Lx_Item_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18371: Lx_System_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
18372: Lx_Cust_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;