DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on OKX_CUSTOMER_ACCOUNTS_V

Line 7792: FROM Okx_Customer_Accounts_V CA

7788: IS
7789:
7790: CURSOR Lx_Csr_CovCust(Cx_CovCust_Id IN Gx_OKS_Id) IS
7791: SELECT CA.Party_Id
7792: FROM Okx_Customer_Accounts_V CA
7793: WHERE CA.Id1 = Cx_CovCust_Id
7794: AND CA.Id2 = '#';
7795:
7796: Lx_CovCust_Obj_Id CONSTANT Gx_OKS_Id := P_CovCust_Obj_Id;

Line 7805: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;

7801:
7802: Lx_Result Gx_Boolean;
7803: Lx_Return_Status Gx_Ret_Sts;
7804:
7805: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
7806:
7807: Li_TableIdx BINARY_INTEGER;
7808: L_EXCEP_UNEXPECTED_ERR EXCEPTION;
7809: L_EXCEP_NO_DATA_FOUND EXCEPTION;

Line 7933: Lx_Party_Id_Dummy Okx_Customer_Accounts_V.Party_Id%TYPE;

7929: Lx_Return_Status Gx_Ret_Sts;
7930:
7931: Lx_Cust_Account_Id Okx_Cust_Site_Uses_V.Cust_Account_Id%TYPE;
7932: Lx_Party_Id Okx_Cust_Site_Uses_V.Party_Id%TYPE;
7933: Lx_Party_Id_Dummy Okx_Customer_Accounts_V.Party_Id%TYPE;
7934:
7935: Li_TableIdx BINARY_INTEGER;
7936:
7937: L_EXCEP_UNEXPECTED_ERR EXCEPTION;

Line 8059: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;

8055:
8056: Lx_System_Customer GT_ContItem_Ref;
8057: Lx_System_Site GT_ContItem_Ref;
8058:
8059: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
8060:
8061: Lx_Result Gx_Boolean;
8062: Lx_Return_Status Gx_Ret_Sts;
8063:

Line 8353: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;

8349: Lx_Customer_Id Okx_Customer_Products_V.Customer_Id%TYPE;
8350: Lx_Site_Id Okx_Customer_Products_V.Install_Site_Use_Id%TYPE;
8351: */
8352:
8353: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
8354: Lx_Inv_Item_Id CSI_ITEM_INSTANCES.Inventory_Item_Id%TYPE;
8355: Lx_System_Id CSI_ITEM_INSTANCES.System_Id%TYPE;
8356: Lx_Customer_Id CSI_ITEM_INSTANCES.Owner_Party_Id%TYPE;
8357: Lx_Site_Id CSI_ITEM_INSTANCES.Install_location_id%TYPE;

Line 9001: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;

8997: Lx_CovProd_Obj_Id CONSTANT Gx_OKS_Id := P_CovProd_Obj_Id;
8998: Ln_Organization_Id CONSTANT NUMBER := P_Organization_Id;
8999: Ln_Org_Id CONSTANT NUMBER := P_Org_Id;
9000:
9001: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
9002:
9003: Lx_Product_CovLevels GT_ContItem_Ref;
9004: Lx_CovProd_Contracts GT_Contract_Ref;
9005:

Line 9336: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;

9332:
9333: Lx_Cust_CovLevels GT_ContItem_Ref;
9334: Lx_CovCust_Contracts GT_Contract_Ref;
9335:
9336: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
9337:
9338: Lx_Result Gx_Boolean;
9339: Lx_Return_Status Gx_Ret_Sts;
9340:

Line 16524: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;

16520: l_contract_line_id NUMBER;
16521: l_busiproc_match VARCHAR2(1);
16522: j NUMBER ;
16523:
16524: Lx_Party_Id Okx_Customer_Accounts_V.Party_Id%TYPE;
16525: Lx_Product_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
16526: Lx_Item_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
16527: Lx_System_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;
16528: Lx_Cust_CovLevels OKS_ENTITLEMENTS_PVT.GT_ContItem_Ref;