eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_CLAIM_UTILITY_PVT dependencies on OZF_CLAIMS_ALL

Line 574: TYPE claimTbl IS TABLE OF ozf_claims_all.claim_number%TYPE;

570: l_return_status VARCHAR2(10);
571:
572: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
573:
574: TYPE claimTbl IS TABLE OF ozf_claims_all.claim_number%TYPE;
575: TYPE amountTbl IS TABLE OF ozf_claims_all.amount%TYPE;
576: TYPE acctdamountTbl IS TABLE OF ozf_claims_all.acctd_amount%TYPE;
577: TYPE claimidTbl IS TABLE OF ozf_claims_all.claim_id%TYPE;
578: TYPE custrefdTbl IS TABLE OF ozf_claims_all.customer_ref_number%TYPE;

Line 575: TYPE amountTbl IS TABLE OF ozf_claims_all.amount%TYPE;

571:
572: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
573:
574: TYPE claimTbl IS TABLE OF ozf_claims_all.claim_number%TYPE;
575: TYPE amountTbl IS TABLE OF ozf_claims_all.amount%TYPE;
576: TYPE acctdamountTbl IS TABLE OF ozf_claims_all.acctd_amount%TYPE;
577: TYPE claimidTbl IS TABLE OF ozf_claims_all.claim_id%TYPE;
578: TYPE custrefdTbl IS TABLE OF ozf_claims_all.customer_ref_number%TYPE;
579: TYPE custrefnormTbl IS TABLE OF ozf_claims_all.customer_ref_normalized%TYPE;

Line 576: TYPE acctdamountTbl IS TABLE OF ozf_claims_all.acctd_amount%TYPE;

572: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
573:
574: TYPE claimTbl IS TABLE OF ozf_claims_all.claim_number%TYPE;
575: TYPE amountTbl IS TABLE OF ozf_claims_all.amount%TYPE;
576: TYPE acctdamountTbl IS TABLE OF ozf_claims_all.acctd_amount%TYPE;
577: TYPE claimidTbl IS TABLE OF ozf_claims_all.claim_id%TYPE;
578: TYPE custrefdTbl IS TABLE OF ozf_claims_all.customer_ref_number%TYPE;
579: TYPE custrefnormTbl IS TABLE OF ozf_claims_all.customer_ref_normalized%TYPE;
580: TYPE custaccountTbl IS TABLE OF ozf_claims_all.cust_account_id%TYPE;

Line 577: TYPE claimidTbl IS TABLE OF ozf_claims_all.claim_id%TYPE;

573:
574: TYPE claimTbl IS TABLE OF ozf_claims_all.claim_number%TYPE;
575: TYPE amountTbl IS TABLE OF ozf_claims_all.amount%TYPE;
576: TYPE acctdamountTbl IS TABLE OF ozf_claims_all.acctd_amount%TYPE;
577: TYPE claimidTbl IS TABLE OF ozf_claims_all.claim_id%TYPE;
578: TYPE custrefdTbl IS TABLE OF ozf_claims_all.customer_ref_number%TYPE;
579: TYPE custrefnormTbl IS TABLE OF ozf_claims_all.customer_ref_normalized%TYPE;
580: TYPE custaccountTbl IS TABLE OF ozf_claims_all.cust_account_id%TYPE;
581: TYPE custbilltositeTbl IS TABLE OF ozf_claims_all.cust_billto_acct_site_id%TYPE;

Line 578: TYPE custrefdTbl IS TABLE OF ozf_claims_all.customer_ref_number%TYPE;

574: TYPE claimTbl IS TABLE OF ozf_claims_all.claim_number%TYPE;
575: TYPE amountTbl IS TABLE OF ozf_claims_all.amount%TYPE;
576: TYPE acctdamountTbl IS TABLE OF ozf_claims_all.acctd_amount%TYPE;
577: TYPE claimidTbl IS TABLE OF ozf_claims_all.claim_id%TYPE;
578: TYPE custrefdTbl IS TABLE OF ozf_claims_all.customer_ref_number%TYPE;
579: TYPE custrefnormTbl IS TABLE OF ozf_claims_all.customer_ref_normalized%TYPE;
580: TYPE custaccountTbl IS TABLE OF ozf_claims_all.cust_account_id%TYPE;
581: TYPE custbilltositeTbl IS TABLE OF ozf_claims_all.cust_billto_acct_site_id%TYPE;
582: TYPE claimobjverTbl IS TABLE OF ozf_claims_all.object_version_number%TYPE;

Line 579: TYPE custrefnormTbl IS TABLE OF ozf_claims_all.customer_ref_normalized%TYPE;

575: TYPE amountTbl IS TABLE OF ozf_claims_all.amount%TYPE;
576: TYPE acctdamountTbl IS TABLE OF ozf_claims_all.acctd_amount%TYPE;
577: TYPE claimidTbl IS TABLE OF ozf_claims_all.claim_id%TYPE;
578: TYPE custrefdTbl IS TABLE OF ozf_claims_all.customer_ref_number%TYPE;
579: TYPE custrefnormTbl IS TABLE OF ozf_claims_all.customer_ref_normalized%TYPE;
580: TYPE custaccountTbl IS TABLE OF ozf_claims_all.cust_account_id%TYPE;
581: TYPE custbilltositeTbl IS TABLE OF ozf_claims_all.cust_billto_acct_site_id%TYPE;
582: TYPE claimobjverTbl IS TABLE OF ozf_claims_all.object_version_number%TYPE;
583: TYPE curcodeTbl IS TABLE OF ozf_claims_all.currency_code%TYPE;

Line 580: TYPE custaccountTbl IS TABLE OF ozf_claims_all.cust_account_id%TYPE;

576: TYPE acctdamountTbl IS TABLE OF ozf_claims_all.acctd_amount%TYPE;
577: TYPE claimidTbl IS TABLE OF ozf_claims_all.claim_id%TYPE;
578: TYPE custrefdTbl IS TABLE OF ozf_claims_all.customer_ref_number%TYPE;
579: TYPE custrefnormTbl IS TABLE OF ozf_claims_all.customer_ref_normalized%TYPE;
580: TYPE custaccountTbl IS TABLE OF ozf_claims_all.cust_account_id%TYPE;
581: TYPE custbilltositeTbl IS TABLE OF ozf_claims_all.cust_billto_acct_site_id%TYPE;
582: TYPE claimobjverTbl IS TABLE OF ozf_claims_all.object_version_number%TYPE;
583: TYPE curcodeTbl IS TABLE OF ozf_claims_all.currency_code%TYPE;
584: TYPE padTbl IS TABLE OF ozf_claims_all.pre_auth_deduction_number%TYPE;

Line 581: TYPE custbilltositeTbl IS TABLE OF ozf_claims_all.cust_billto_acct_site_id%TYPE;

577: TYPE claimidTbl IS TABLE OF ozf_claims_all.claim_id%TYPE;
578: TYPE custrefdTbl IS TABLE OF ozf_claims_all.customer_ref_number%TYPE;
579: TYPE custrefnormTbl IS TABLE OF ozf_claims_all.customer_ref_normalized%TYPE;
580: TYPE custaccountTbl IS TABLE OF ozf_claims_all.cust_account_id%TYPE;
581: TYPE custbilltositeTbl IS TABLE OF ozf_claims_all.cust_billto_acct_site_id%TYPE;
582: TYPE claimobjverTbl IS TABLE OF ozf_claims_all.object_version_number%TYPE;
583: TYPE curcodeTbl IS TABLE OF ozf_claims_all.currency_code%TYPE;
584: TYPE padTbl IS TABLE OF ozf_claims_all.pre_auth_deduction_number%TYPE;
585: TYPE padnormTbl IS TABLE OF ozf_claims_all.pre_auth_deduction_normalized%TYPE;

Line 582: TYPE claimobjverTbl IS TABLE OF ozf_claims_all.object_version_number%TYPE;

578: TYPE custrefdTbl IS TABLE OF ozf_claims_all.customer_ref_number%TYPE;
579: TYPE custrefnormTbl IS TABLE OF ozf_claims_all.customer_ref_normalized%TYPE;
580: TYPE custaccountTbl IS TABLE OF ozf_claims_all.cust_account_id%TYPE;
581: TYPE custbilltositeTbl IS TABLE OF ozf_claims_all.cust_billto_acct_site_id%TYPE;
582: TYPE claimobjverTbl IS TABLE OF ozf_claims_all.object_version_number%TYPE;
583: TYPE curcodeTbl IS TABLE OF ozf_claims_all.currency_code%TYPE;
584: TYPE padTbl IS TABLE OF ozf_claims_all.pre_auth_deduction_number%TYPE;
585: TYPE padnormTbl IS TABLE OF ozf_claims_all.pre_auth_deduction_normalized%TYPE;
586: TYPE siteUseIdTbl IS TABLE OF ozf_claims_all.cust_billto_acct_site_id%TYPE;

Line 583: TYPE curcodeTbl IS TABLE OF ozf_claims_all.currency_code%TYPE;

579: TYPE custrefnormTbl IS TABLE OF ozf_claims_all.customer_ref_normalized%TYPE;
580: TYPE custaccountTbl IS TABLE OF ozf_claims_all.cust_account_id%TYPE;
581: TYPE custbilltositeTbl IS TABLE OF ozf_claims_all.cust_billto_acct_site_id%TYPE;
582: TYPE claimobjverTbl IS TABLE OF ozf_claims_all.object_version_number%TYPE;
583: TYPE curcodeTbl IS TABLE OF ozf_claims_all.currency_code%TYPE;
584: TYPE padTbl IS TABLE OF ozf_claims_all.pre_auth_deduction_number%TYPE;
585: TYPE padnormTbl IS TABLE OF ozf_claims_all.pre_auth_deduction_normalized%TYPE;
586: TYPE siteUseIdTbl IS TABLE OF ozf_claims_all.cust_billto_acct_site_id%TYPE;
587: TYPE offerIdTbl IS TABLE OF ozf_claims_all.offer_id%TYPE;

Line 584: TYPE padTbl IS TABLE OF ozf_claims_all.pre_auth_deduction_number%TYPE;

580: TYPE custaccountTbl IS TABLE OF ozf_claims_all.cust_account_id%TYPE;
581: TYPE custbilltositeTbl IS TABLE OF ozf_claims_all.cust_billto_acct_site_id%TYPE;
582: TYPE claimobjverTbl IS TABLE OF ozf_claims_all.object_version_number%TYPE;
583: TYPE curcodeTbl IS TABLE OF ozf_claims_all.currency_code%TYPE;
584: TYPE padTbl IS TABLE OF ozf_claims_all.pre_auth_deduction_number%TYPE;
585: TYPE padnormTbl IS TABLE OF ozf_claims_all.pre_auth_deduction_normalized%TYPE;
586: TYPE siteUseIdTbl IS TABLE OF ozf_claims_all.cust_billto_acct_site_id%TYPE;
587: TYPE offerIdTbl IS TABLE OF ozf_claims_all.offer_id%TYPE;
588:

Line 585: TYPE padnormTbl IS TABLE OF ozf_claims_all.pre_auth_deduction_normalized%TYPE;

581: TYPE custbilltositeTbl IS TABLE OF ozf_claims_all.cust_billto_acct_site_id%TYPE;
582: TYPE claimobjverTbl IS TABLE OF ozf_claims_all.object_version_number%TYPE;
583: TYPE curcodeTbl IS TABLE OF ozf_claims_all.currency_code%TYPE;
584: TYPE padTbl IS TABLE OF ozf_claims_all.pre_auth_deduction_number%TYPE;
585: TYPE padnormTbl IS TABLE OF ozf_claims_all.pre_auth_deduction_normalized%TYPE;
586: TYPE siteUseIdTbl IS TABLE OF ozf_claims_all.cust_billto_acct_site_id%TYPE;
587: TYPE offerIdTbl IS TABLE OF ozf_claims_all.offer_id%TYPE;
588:
589:

Line 586: TYPE siteUseIdTbl IS TABLE OF ozf_claims_all.cust_billto_acct_site_id%TYPE;

582: TYPE claimobjverTbl IS TABLE OF ozf_claims_all.object_version_number%TYPE;
583: TYPE curcodeTbl IS TABLE OF ozf_claims_all.currency_code%TYPE;
584: TYPE padTbl IS TABLE OF ozf_claims_all.pre_auth_deduction_number%TYPE;
585: TYPE padnormTbl IS TABLE OF ozf_claims_all.pre_auth_deduction_normalized%TYPE;
586: TYPE siteUseIdTbl IS TABLE OF ozf_claims_all.cust_billto_acct_site_id%TYPE;
587: TYPE offerIdTbl IS TABLE OF ozf_claims_all.offer_id%TYPE;
588:
589:
590: -- For System Parameter Check

Line 587: TYPE offerIdTbl IS TABLE OF ozf_claims_all.offer_id%TYPE;

583: TYPE curcodeTbl IS TABLE OF ozf_claims_all.currency_code%TYPE;
584: TYPE padTbl IS TABLE OF ozf_claims_all.pre_auth_deduction_number%TYPE;
585: TYPE padnormTbl IS TABLE OF ozf_claims_all.pre_auth_deduction_normalized%TYPE;
586: TYPE siteUseIdTbl IS TABLE OF ozf_claims_all.cust_billto_acct_site_id%TYPE;
587: TYPE offerIdTbl IS TABLE OF ozf_claims_all.offer_id%TYPE;
588:
589:
590: -- For System Parameter Check
591: l_enable_rule_based VARCHAR2(1);

Line 631: FROM ozf_claims_all

627: pre_auth_deduction_number,
628: pre_auth_deduction_normalized,
629: cust_billto_acct_site_id,
630: offer_id
631: FROM ozf_claims_all
632: WHERE
633: status_code = 'OPEN'
634: AND claim_class = 'DEDUCTION'
635: AND (customer_ref_number IS NOT NULL