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_CUST_FACTS_PVT dependencies on OZF_CUST_FACTS_PVT

Line 1: PACKAGE BODY OZF_CUST_FACTS_PVT AS

1: PACKAGE BODY OZF_CUST_FACTS_PVT AS
2: /*$Header: ozfvcftb.pls 120.13 2011/03/25 09:45:46 kdass ship $*/
3:
4: PROCEDURE refresh_accts_and_products(
5: p_api_version IN NUMBER,

Line 966: DECODE( prod.item_type, 'OTHERS', ozf_cust_facts_pvt.get_cust_target (

962: p_bill_to_site_use_id NUMBER,
963: p_period_type_id NUMBER,
964: p_time_id NUMBER) IS
965: SELECT SUM(
966: DECODE( prod.item_type, 'OTHERS', ozf_cust_facts_pvt.get_cust_target (
967: cust.site_use_id,
968: cust.bill_to_site_use_id,
969: time.period_type_id ,
970: time.time_id,

Line 2682: ozf_cust_facts_pvt.get_cust_target( outer.party_id, NULL, NULL,

2678: Set (PERIOD_QUOTA, QTR_QUOTA, YEAR_QUOTA)
2679: =
2680: (
2681: SELECT
2682: ozf_cust_facts_pvt.get_cust_target( outer.party_id, NULL, NULL,
2683: 'PERIOD_QUOTA', 0,
2684: outer.report_date,outer.resource_id
2685: ) PERIOD_QUOTA,
2686: ozf_cust_facts_pvt.get_cust_target( outer.party_id, NULL, NULL,

Line 2686: ozf_cust_facts_pvt.get_cust_target( outer.party_id, NULL, NULL,

2682: ozf_cust_facts_pvt.get_cust_target( outer.party_id, NULL, NULL,
2683: 'PERIOD_QUOTA', 0,
2684: outer.report_date,outer.resource_id
2685: ) PERIOD_QUOTA,
2686: ozf_cust_facts_pvt.get_cust_target( outer.party_id, NULL, NULL,
2687: 'QTR_QUOTA', 0,
2688: outer.report_date,outer.resource_id
2689: ) QTR_QUOTA,
2690: ozf_cust_facts_pvt.get_cust_target( outer.party_id, NULL, NULL,

Line 2690: ozf_cust_facts_pvt.get_cust_target( outer.party_id, NULL, NULL,

2686: ozf_cust_facts_pvt.get_cust_target( outer.party_id, NULL, NULL,
2687: 'QTR_QUOTA', 0,
2688: outer.report_date,outer.resource_id
2689: ) QTR_QUOTA,
2690: ozf_cust_facts_pvt.get_cust_target( outer.party_id, NULL, NULL,
2691: 'YEAR_QUOTA', 0,
2692: outer.report_date,outer.resource_id
2693: ) YEAR_QUOTA
2694: FROM dual

Line 2705: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,

2701: Set (PERIOD_QUOTA, QTR_QUOTA, YEAR_QUOTA)
2702: =
2703: (
2704: SELECT
2705: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,
2706: NULL, 'PERIOD_QUOTA', 0,
2707: outer.report_date,outer.resource_id
2708: ) PERIOD_QUOTA,
2709: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,

Line 2709: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,

2705: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,
2706: NULL, 'PERIOD_QUOTA', 0,
2707: outer.report_date,outer.resource_id
2708: ) PERIOD_QUOTA,
2709: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,
2710: NULL, 'QTR_QUOTA', 0,
2711: outer.report_date,outer.resource_id
2712: ) QTR_QUOTA,
2713: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,

Line 2713: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,

2709: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,
2710: NULL, 'QTR_QUOTA', 0,
2711: outer.report_date,outer.resource_id
2712: ) QTR_QUOTA,
2713: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,
2714: NULL, 'YEAR_QUOTA', 0,
2715: outer.report_date,outer.resource_id
2716: ) YEAR_QUOTA
2717: FROM dual

Line 2728: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,

2724: Set (PERIOD_QUOTA, QTR_QUOTA, YEAR_QUOTA)
2725: =
2726: (
2727: SELECT
2728: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,
2729: outer.ship_to_site_use_id, 'PERIOD_QUOTA', 0,
2730: outer.report_date,outer.resource_id
2731: ) PERIOD_QUOTA,
2732: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,

Line 2732: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,

2728: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,
2729: outer.ship_to_site_use_id, 'PERIOD_QUOTA', 0,
2730: outer.report_date,outer.resource_id
2731: ) PERIOD_QUOTA,
2732: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,
2733: outer.ship_to_site_use_id, 'QTR_QUOTA', 0,
2734: outer.report_date,outer.resource_id
2735: ) QTR_QUOTA,
2736: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,

Line 2736: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,

2732: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,
2733: outer.ship_to_site_use_id, 'QTR_QUOTA', 0,
2734: outer.report_date,outer.resource_id
2735: ) QTR_QUOTA,
2736: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,
2737: outer.ship_to_site_use_id, 'YEAR_QUOTA', 0,
2738: outer.report_date,outer.resource_id
2739: ) YEAR_QUOTA
2740: FROM dual

Line 3809: SELECT ozf_cust_facts_pvt.get_cust_target ( b.site_use_id,

3805:
3806: -- Get Quota for the give time period
3807: /*
3808: CURSOR quota_csr IS
3809: SELECT ozf_cust_facts_pvt.get_cust_target ( b.site_use_id,
3810: b.bill_to_site_use_id,
3811: c.period_type_id ,
3812: c.time_id) target
3813: FROM ozf_product_allocations a

Line 4078: END ozf_cust_facts_pvt;

4074: WHEN OTHERS THEN
4075: RETURN -9999;
4076: END get_xtd_total ;
4077:
4078: END ozf_cust_facts_pvt;