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.AMS_ACTMETRICS_SEED_PVT dependencies on AMS_ACTMETRICS_SEED_PVT

Line 1: PACKAGE BODY AMS_ACTMETRICS_SEED_PVT AS

1: PACKAGE BODY AMS_ACTMETRICS_SEED_PVT AS
2: /* $Header: amsvamsb.pls 120.20.12010000.2 2008/08/12 08:11:47 amlal ship $ */
3: --------------------------------------------------------------------------------
4: --
5: -- NAME

Line 6: -- AMS_ACTMETRICS_SEED_PVT 12.0

2: /* $Header: amsvamsb.pls 120.20.12010000.2 2008/08/12 08:11:47 amlal ship $ */
3: --------------------------------------------------------------------------------
4: --
5: -- NAME
6: -- AMS_ACTMETRICS_SEED_PVT 12.0
7: --
8: -- HISTORY
9: -- 30-Aug-2001 dmvincen Created
10: -- 05-Sep-2001 dmvincen Checking for changed values only.

Line 72: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_ACTMETRICS_SEED_PVT';

68: --
69: -- Global variables and constants.
70: --
71: -- Name of the current package.
72: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_ACTMETRICS_SEED_PVT';
73:
74: G_FUNCTION_NAME CONSTANT VARCHAR2(80) :='AMS_ACTMETRICS_SEED_PVT.CALCULATE_SEEDED_METRICS';
75:
76: -- sunkumar Added 11.5.10: 05-August-2003

Line 74: G_FUNCTION_NAME CONSTANT VARCHAR2(80) :='AMS_ACTMETRICS_SEED_PVT.CALCULATE_SEEDED_METRICS';

70: --
71: -- Name of the current package.
72: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_ACTMETRICS_SEED_PVT';
73:
74: G_FUNCTION_NAME CONSTANT VARCHAR2(80) :='AMS_ACTMETRICS_SEED_PVT.CALCULATE_SEEDED_METRICS';
75:
76: -- sunkumar Added 11.5.10: 05-August-2003
77: G_TARGET_FUNCTION_NAME CONSTANT VARCHAR2(80) :='AMS_ACTMETRICS_SEED_PVT.CALCULATE_TARGET_GROUP';
78: G_LIST_FUNCTION_NAME CONSTANT VARCHAR2(80) := 'AMS_ACTMETRICS_SEED_PVT.CALCULATE_SEEDED_LIST_METRICS';

Line 77: G_TARGET_FUNCTION_NAME CONSTANT VARCHAR2(80) :='AMS_ACTMETRICS_SEED_PVT.CALCULATE_TARGET_GROUP';

73:
74: G_FUNCTION_NAME CONSTANT VARCHAR2(80) :='AMS_ACTMETRICS_SEED_PVT.CALCULATE_SEEDED_METRICS';
75:
76: -- sunkumar Added 11.5.10: 05-August-2003
77: G_TARGET_FUNCTION_NAME CONSTANT VARCHAR2(80) :='AMS_ACTMETRICS_SEED_PVT.CALCULATE_TARGET_GROUP';
78: G_LIST_FUNCTION_NAME CONSTANT VARCHAR2(80) := 'AMS_ACTMETRICS_SEED_PVT.CALCULATE_SEEDED_LIST_METRICS';
79:
80: G_DEAD_LEAD_STATUS fnd_profile_option_values.profile_option_value%TYPE := fnd_profile.value('AS_DEAD_LEAD_STATUS');
81: G_LEAD_LINK_STATUS fnd_profile_option_values.profile_option_value%TYPE := fnd_profile.value('AS_LEAD_LINK_STATUS');

Line 78: G_LIST_FUNCTION_NAME CONSTANT VARCHAR2(80) := 'AMS_ACTMETRICS_SEED_PVT.CALCULATE_SEEDED_LIST_METRICS';

74: G_FUNCTION_NAME CONSTANT VARCHAR2(80) :='AMS_ACTMETRICS_SEED_PVT.CALCULATE_SEEDED_METRICS';
75:
76: -- sunkumar Added 11.5.10: 05-August-2003
77: G_TARGET_FUNCTION_NAME CONSTANT VARCHAR2(80) :='AMS_ACTMETRICS_SEED_PVT.CALCULATE_TARGET_GROUP';
78: G_LIST_FUNCTION_NAME CONSTANT VARCHAR2(80) := 'AMS_ACTMETRICS_SEED_PVT.CALCULATE_SEEDED_LIST_METRICS';
79:
80: G_DEAD_LEAD_STATUS fnd_profile_option_values.profile_option_value%TYPE := fnd_profile.value('AS_DEAD_LEAD_STATUS');
81: G_LEAD_LINK_STATUS fnd_profile_option_values.profile_option_value%TYPE := fnd_profile.value('AS_LEAD_LINK_STATUS');
82: -- sunkumar end additions

Line 713: SUM(AMS_ACTMETRICS_SEED_PVT.CONVERT_CURRENCY(CURRENCY_CODE, BOOKED_REVENUE)) BOOKED_REVENUE,

709: , 0 ) ACTUAL_VALUE, ACTIVITY_METRIC_ID, FUNC_ACTUAL_VALUE
710: FROM
711: (SELECT ARC_SOURCE_CODE_FOR, SOURCE_CODE_FOR_ID,
712: COUNT(DISTINCT H.HEADER_ID) ORDER_COUNT,
713: SUM(AMS_ACTMETRICS_SEED_PVT.CONVERT_CURRENCY(CURRENCY_CODE, BOOKED_REVENUE)) BOOKED_REVENUE,
714: SUM(AMS_ACTMETRICS_SEED_PVT.CONVERT_CURRENCY(CURRENCY_CODE, INVOICED_REVENUE)) INVOICED_REVENUE
715: FROM
716: (SELECT H.ARC_SOURCE_CODE_FOR, H.SOURCE_CODE_FOR_ID, H.HEADER_ID,
717: SUM(NVL(H.UNIT_SELLING_PRICE * H.ORDERED_QUANTITY,0)) BOOKED_REVENUE,

Line 714: SUM(AMS_ACTMETRICS_SEED_PVT.CONVERT_CURRENCY(CURRENCY_CODE, INVOICED_REVENUE)) INVOICED_REVENUE

710: FROM
711: (SELECT ARC_SOURCE_CODE_FOR, SOURCE_CODE_FOR_ID,
712: COUNT(DISTINCT H.HEADER_ID) ORDER_COUNT,
713: SUM(AMS_ACTMETRICS_SEED_PVT.CONVERT_CURRENCY(CURRENCY_CODE, BOOKED_REVENUE)) BOOKED_REVENUE,
714: SUM(AMS_ACTMETRICS_SEED_PVT.CONVERT_CURRENCY(CURRENCY_CODE, INVOICED_REVENUE)) INVOICED_REVENUE
715: FROM
716: (SELECT H.ARC_SOURCE_CODE_FOR, H.SOURCE_CODE_FOR_ID, H.HEADER_ID,
717: SUM(NVL(H.UNIT_SELLING_PRICE * H.ORDERED_QUANTITY,0)) BOOKED_REVENUE,
718: SUM(NVL(H.UNIT_SELLING_PRICE * ABS(H.INVOICED_QUANTITY),0)) INVOICED_REVENUE,

Line 2269: sum(ams_actmetrics_seed_pvt.convert_currency(currency_code, booked_revenue)) booked_revenue,

2265: FROM
2266: (SELECT
2267: object_type, object_id,
2268: count(DISTINCT h.header_id) order_count,
2269: sum(ams_actmetrics_seed_pvt.convert_currency(currency_code, booked_revenue)) booked_revenue,
2270: sum(ams_actmetrics_seed_pvt.convert_currency(currency_code, invoiced_revenue)) invoiced_revenue
2271: FROM
2272: (SELECT H.object_type, H.object_id, H.header_id,
2273: sum(nvl(H.unit_selling_price * H.ordered_quantity,0)) booked_revenue,

Line 2270: sum(ams_actmetrics_seed_pvt.convert_currency(currency_code, invoiced_revenue)) invoiced_revenue

2266: (SELECT
2267: object_type, object_id,
2268: count(DISTINCT h.header_id) order_count,
2269: sum(ams_actmetrics_seed_pvt.convert_currency(currency_code, booked_revenue)) booked_revenue,
2270: sum(ams_actmetrics_seed_pvt.convert_currency(currency_code, invoiced_revenue)) invoiced_revenue
2271: FROM
2272: (SELECT H.object_type, H.object_id, H.header_id,
2273: sum(nvl(H.unit_selling_price * H.ordered_quantity,0)) booked_revenue,
2274: sum(nvl(H.unit_selling_price * abs(H.invoiced_quantity),0)) invoiced_revenue,

Line 2893: sum(ams_actmetrics_seed_pvt.convert_currency(currency_code, booked_revenue)) booked_revenue

2889: (SELECT
2890: ACTIVITY_METRIC_ID,
2891: count(distinct nvl(contact_rel_party_id, primary_party_id)) targets,
2892: count(DISTINCT header_id) order_count,
2893: sum(ams_actmetrics_seed_pvt.convert_currency(currency_code, booked_revenue)) booked_revenue
2894: FROM (
2895: SELECT /*+ ordered */ H.header_id, H.transactional_curr_code currency_code,
2896: sum(nvl(I.ordered_quantity * I.unit_selling_price,0)) booked_revenue,
2897: csch_parties.ACTIVITY_METRIC_ID,

Line 3038: sum(ams_actmetrics_seed_pvt.convert_currency(currency_code, booked_revenue)) booked_revenue

3034: (SELECT
3035: ACTIVITY_METRIC_ID,
3036: count(distinct nvl(contact_rel_party_id, primary_party_id)) targets,
3037: count(DISTINCT header_id) order_count,
3038: sum(ams_actmetrics_seed_pvt.convert_currency(currency_code, booked_revenue)) booked_revenue
3039: FROM (
3040: SELECT /*+ ordered */ H.header_id, H.transactional_curr_code currency_code,
3041: sum(nvl(I.ordered_quantity * I.unit_selling_price,0)) booked_revenue,
3042: csch_parties.ACTIVITY_METRIC_ID,

Line 3406: sum(ams_actmetrics_seed_pvt.convert_currency(currency_code, booked_revenue)) booked_revenue

3402: (SELECT
3403: ACTIVITY_METRIC_ID,
3404: count(distinct nvl(contact_rel_party_id, primary_party_id)) targets,
3405: count(DISTINCT header_id) order_count,
3406: sum(ams_actmetrics_seed_pvt.convert_currency(currency_code, booked_revenue)) booked_revenue
3407: FROM (
3408: SELECT /*+ ordered USE_NL(ACCOUNT H) */ H.header_id, H.transactional_curr_code currency_code,
3409: sum(nvl(I.ordered_quantity * I.unit_selling_price,0)) booked_revenue,
3410: csch_parties.ACTIVITY_METRIC_ID,

Line 3620: END Ams_Actmetrics_Seed_Pvt;

3616: END IF;
3617:
3618: end;
3619:
3620: END Ams_Actmetrics_Seed_Pvt;