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.AS_SC_DENORM dependencies on AS_SALES_CREDITS_DENORM

Line 9: -- AS_SALES_CREDITS_DENORM

5: -- HISTORY
6: -- 04/07/2000 NACHARYA Created
7: -- 12/22/2000 SOLIN Bug 1549115
8: -- Add a new column BUSINESS_GROUP_NAME in
9: -- AS_SALES_CREDITS_DENORM
10: -- 06/20/2001 SMALLINA Bug 1836786
11:
12: -- Constants
13: G_PKG_NAME Constant VARCHAR2(30):='AS_SC_REFRESH_DENORM';

Line 30: Type sales_credit_id_list is Table of as_sales_credits_denorm.sales_credit_id%type Index by Binary_integer;

26: G_PREFERRED_CURRENCY as_period_rates.TO_CURRENCY%Type := FND_PROFILE.VALUE('AS_PREFERRED_CURRENCY');
27: G_CONVERSION_TYPE as_period_rates.conversion_type%Type :=FND_PROFILE.VALUE('AS_MC_DAILY_CONVERSION_TYPE');
28: G_PERIOD_TYPE as_period_rates.PERIOD_TYPE%Type := FND_PROFILE.VALUE('AS_DEFAULT_PERIOD_TYPE');
29:
30: Type sales_credit_id_list is Table of as_sales_credits_denorm.sales_credit_id%type Index by Binary_integer;
31: Type sales_group_name_list is Table of as_sales_credits_denorm.sales_group_name%type Index by Binary_integer;
32: Type sales_rep_name_list is Table of as_sales_credits_denorm.sales_rep_name%type Index by Binary_integer;
33: Type employee_number_list is Table of as_sales_credits_denorm.employee_number%type Index by Binary_integer;
34: Type customer_name_list is Table of as_sales_credits_denorm.customer_name%type Index by Binary_integer;

Line 31: Type sales_group_name_list is Table of as_sales_credits_denorm.sales_group_name%type Index by Binary_integer;

27: G_CONVERSION_TYPE as_period_rates.conversion_type%Type :=FND_PROFILE.VALUE('AS_MC_DAILY_CONVERSION_TYPE');
28: G_PERIOD_TYPE as_period_rates.PERIOD_TYPE%Type := FND_PROFILE.VALUE('AS_DEFAULT_PERIOD_TYPE');
29:
30: Type sales_credit_id_list is Table of as_sales_credits_denorm.sales_credit_id%type Index by Binary_integer;
31: Type sales_group_name_list is Table of as_sales_credits_denorm.sales_group_name%type Index by Binary_integer;
32: Type sales_rep_name_list is Table of as_sales_credits_denorm.sales_rep_name%type Index by Binary_integer;
33: Type employee_number_list is Table of as_sales_credits_denorm.employee_number%type Index by Binary_integer;
34: Type customer_name_list is Table of as_sales_credits_denorm.customer_name%type Index by Binary_integer;
35: Type competitor_name_list is Table of as_sales_credits_denorm.competitor_name%type Index by Binary_integer;

Line 32: Type sales_rep_name_list is Table of as_sales_credits_denorm.sales_rep_name%type Index by Binary_integer;

28: G_PERIOD_TYPE as_period_rates.PERIOD_TYPE%Type := FND_PROFILE.VALUE('AS_DEFAULT_PERIOD_TYPE');
29:
30: Type sales_credit_id_list is Table of as_sales_credits_denorm.sales_credit_id%type Index by Binary_integer;
31: Type sales_group_name_list is Table of as_sales_credits_denorm.sales_group_name%type Index by Binary_integer;
32: Type sales_rep_name_list is Table of as_sales_credits_denorm.sales_rep_name%type Index by Binary_integer;
33: Type employee_number_list is Table of as_sales_credits_denorm.employee_number%type Index by Binary_integer;
34: Type customer_name_list is Table of as_sales_credits_denorm.customer_name%type Index by Binary_integer;
35: Type competitor_name_list is Table of as_sales_credits_denorm.competitor_name%type Index by Binary_integer;
36: Type owner_person_name_list is Table of as_sales_credits_denorm.owner_person_name%type Index by Binary_integer;

Line 33: Type employee_number_list is Table of as_sales_credits_denorm.employee_number%type Index by Binary_integer;

29:
30: Type sales_credit_id_list is Table of as_sales_credits_denorm.sales_credit_id%type Index by Binary_integer;
31: Type sales_group_name_list is Table of as_sales_credits_denorm.sales_group_name%type Index by Binary_integer;
32: Type sales_rep_name_list is Table of as_sales_credits_denorm.sales_rep_name%type Index by Binary_integer;
33: Type employee_number_list is Table of as_sales_credits_denorm.employee_number%type Index by Binary_integer;
34: Type customer_name_list is Table of as_sales_credits_denorm.customer_name%type Index by Binary_integer;
35: Type competitor_name_list is Table of as_sales_credits_denorm.competitor_name%type Index by Binary_integer;
36: Type owner_person_name_list is Table of as_sales_credits_denorm.owner_person_name%type Index by Binary_integer;
37: Type owner_last_name_list is Table of as_sales_credits_denorm.owner_last_name%type Index by Binary_integer;

Line 34: Type customer_name_list is Table of as_sales_credits_denorm.customer_name%type Index by Binary_integer;

30: Type sales_credit_id_list is Table of as_sales_credits_denorm.sales_credit_id%type Index by Binary_integer;
31: Type sales_group_name_list is Table of as_sales_credits_denorm.sales_group_name%type Index by Binary_integer;
32: Type sales_rep_name_list is Table of as_sales_credits_denorm.sales_rep_name%type Index by Binary_integer;
33: Type employee_number_list is Table of as_sales_credits_denorm.employee_number%type Index by Binary_integer;
34: Type customer_name_list is Table of as_sales_credits_denorm.customer_name%type Index by Binary_integer;
35: Type competitor_name_list is Table of as_sales_credits_denorm.competitor_name%type Index by Binary_integer;
36: Type owner_person_name_list is Table of as_sales_credits_denorm.owner_person_name%type Index by Binary_integer;
37: Type owner_last_name_list is Table of as_sales_credits_denorm.owner_last_name%type Index by Binary_integer;
38: Type owner_first_name_list is Table of as_sales_credits_denorm.owner_first_name%type Index by Binary_integer;

Line 35: Type competitor_name_list is Table of as_sales_credits_denorm.competitor_name%type Index by Binary_integer;

31: Type sales_group_name_list is Table of as_sales_credits_denorm.sales_group_name%type Index by Binary_integer;
32: Type sales_rep_name_list is Table of as_sales_credits_denorm.sales_rep_name%type Index by Binary_integer;
33: Type employee_number_list is Table of as_sales_credits_denorm.employee_number%type Index by Binary_integer;
34: Type customer_name_list is Table of as_sales_credits_denorm.customer_name%type Index by Binary_integer;
35: Type competitor_name_list is Table of as_sales_credits_denorm.competitor_name%type Index by Binary_integer;
36: Type owner_person_name_list is Table of as_sales_credits_denorm.owner_person_name%type Index by Binary_integer;
37: Type owner_last_name_list is Table of as_sales_credits_denorm.owner_last_name%type Index by Binary_integer;
38: Type owner_first_name_list is Table of as_sales_credits_denorm.owner_first_name%type Index by Binary_integer;
39: Type owner_group_name_list is Table of as_sales_credits_denorm.owner_group_name%type Index by Binary_integer;

Line 36: Type owner_person_name_list is Table of as_sales_credits_denorm.owner_person_name%type Index by Binary_integer;

32: Type sales_rep_name_list is Table of as_sales_credits_denorm.sales_rep_name%type Index by Binary_integer;
33: Type employee_number_list is Table of as_sales_credits_denorm.employee_number%type Index by Binary_integer;
34: Type customer_name_list is Table of as_sales_credits_denorm.customer_name%type Index by Binary_integer;
35: Type competitor_name_list is Table of as_sales_credits_denorm.competitor_name%type Index by Binary_integer;
36: Type owner_person_name_list is Table of as_sales_credits_denorm.owner_person_name%type Index by Binary_integer;
37: Type owner_last_name_list is Table of as_sales_credits_denorm.owner_last_name%type Index by Binary_integer;
38: Type owner_first_name_list is Table of as_sales_credits_denorm.owner_first_name%type Index by Binary_integer;
39: Type owner_group_name_list is Table of as_sales_credits_denorm.owner_group_name%type Index by Binary_integer;
40: Type customer_category_list is Table of as_sales_credits_denorm.customer_category%type Index by Binary_integer;

Line 37: Type owner_last_name_list is Table of as_sales_credits_denorm.owner_last_name%type Index by Binary_integer;

33: Type employee_number_list is Table of as_sales_credits_denorm.employee_number%type Index by Binary_integer;
34: Type customer_name_list is Table of as_sales_credits_denorm.customer_name%type Index by Binary_integer;
35: Type competitor_name_list is Table of as_sales_credits_denorm.competitor_name%type Index by Binary_integer;
36: Type owner_person_name_list is Table of as_sales_credits_denorm.owner_person_name%type Index by Binary_integer;
37: Type owner_last_name_list is Table of as_sales_credits_denorm.owner_last_name%type Index by Binary_integer;
38: Type owner_first_name_list is Table of as_sales_credits_denorm.owner_first_name%type Index by Binary_integer;
39: Type owner_group_name_list is Table of as_sales_credits_denorm.owner_group_name%type Index by Binary_integer;
40: Type customer_category_list is Table of as_sales_credits_denorm.customer_category%type Index by Binary_integer;
41: Type customer_category_code_list is Table of as_sales_credits_denorm.customer_category_code%type Index by Binary_integer;

Line 38: Type owner_first_name_list is Table of as_sales_credits_denorm.owner_first_name%type Index by Binary_integer;

34: Type customer_name_list is Table of as_sales_credits_denorm.customer_name%type Index by Binary_integer;
35: Type competitor_name_list is Table of as_sales_credits_denorm.competitor_name%type Index by Binary_integer;
36: Type owner_person_name_list is Table of as_sales_credits_denorm.owner_person_name%type Index by Binary_integer;
37: Type owner_last_name_list is Table of as_sales_credits_denorm.owner_last_name%type Index by Binary_integer;
38: Type owner_first_name_list is Table of as_sales_credits_denorm.owner_first_name%type Index by Binary_integer;
39: Type owner_group_name_list is Table of as_sales_credits_denorm.owner_group_name%type Index by Binary_integer;
40: Type customer_category_list is Table of as_sales_credits_denorm.customer_category%type Index by Binary_integer;
41: Type customer_category_code_list is Table of as_sales_credits_denorm.customer_category_code%type Index by Binary_integer;
42: Type sales_stage_list is Table of as_sales_credits_denorm.sales_stage%type Index by Binary_integer;

Line 39: Type owner_group_name_list is Table of as_sales_credits_denorm.owner_group_name%type Index by Binary_integer;

35: Type competitor_name_list is Table of as_sales_credits_denorm.competitor_name%type Index by Binary_integer;
36: Type owner_person_name_list is Table of as_sales_credits_denorm.owner_person_name%type Index by Binary_integer;
37: Type owner_last_name_list is Table of as_sales_credits_denorm.owner_last_name%type Index by Binary_integer;
38: Type owner_first_name_list is Table of as_sales_credits_denorm.owner_first_name%type Index by Binary_integer;
39: Type owner_group_name_list is Table of as_sales_credits_denorm.owner_group_name%type Index by Binary_integer;
40: Type customer_category_list is Table of as_sales_credits_denorm.customer_category%type Index by Binary_integer;
41: Type customer_category_code_list is Table of as_sales_credits_denorm.customer_category_code%type Index by Binary_integer;
42: Type sales_stage_list is Table of as_sales_credits_denorm.sales_stage%type Index by Binary_integer;
43: Type status_list is Table of as_sales_credits_denorm.status%type Index by Binary_integer;

Line 40: Type customer_category_list is Table of as_sales_credits_denorm.customer_category%type Index by Binary_integer;

36: Type owner_person_name_list is Table of as_sales_credits_denorm.owner_person_name%type Index by Binary_integer;
37: Type owner_last_name_list is Table of as_sales_credits_denorm.owner_last_name%type Index by Binary_integer;
38: Type owner_first_name_list is Table of as_sales_credits_denorm.owner_first_name%type Index by Binary_integer;
39: Type owner_group_name_list is Table of as_sales_credits_denorm.owner_group_name%type Index by Binary_integer;
40: Type customer_category_list is Table of as_sales_credits_denorm.customer_category%type Index by Binary_integer;
41: Type customer_category_code_list is Table of as_sales_credits_denorm.customer_category_code%type Index by Binary_integer;
42: Type sales_stage_list is Table of as_sales_credits_denorm.sales_stage%type Index by Binary_integer;
43: Type status_list is Table of as_sales_credits_denorm.status%type Index by Binary_integer;
44: Type last_name_list is Table of as_sales_credits_denorm.last_name%type Index by Binary_integer;

Line 41: Type customer_category_code_list is Table of as_sales_credits_denorm.customer_category_code%type Index by Binary_integer;

37: Type owner_last_name_list is Table of as_sales_credits_denorm.owner_last_name%type Index by Binary_integer;
38: Type owner_first_name_list is Table of as_sales_credits_denorm.owner_first_name%type Index by Binary_integer;
39: Type owner_group_name_list is Table of as_sales_credits_denorm.owner_group_name%type Index by Binary_integer;
40: Type customer_category_list is Table of as_sales_credits_denorm.customer_category%type Index by Binary_integer;
41: Type customer_category_code_list is Table of as_sales_credits_denorm.customer_category_code%type Index by Binary_integer;
42: Type sales_stage_list is Table of as_sales_credits_denorm.sales_stage%type Index by Binary_integer;
43: Type status_list is Table of as_sales_credits_denorm.status%type Index by Binary_integer;
44: Type last_name_list is Table of as_sales_credits_denorm.last_name%type Index by Binary_integer;
45: Type first_name_list is Table of as_sales_credits_denorm.first_name%type Index by Binary_integer;

Line 42: Type sales_stage_list is Table of as_sales_credits_denorm.sales_stage%type Index by Binary_integer;

38: Type owner_first_name_list is Table of as_sales_credits_denorm.owner_first_name%type Index by Binary_integer;
39: Type owner_group_name_list is Table of as_sales_credits_denorm.owner_group_name%type Index by Binary_integer;
40: Type customer_category_list is Table of as_sales_credits_denorm.customer_category%type Index by Binary_integer;
41: Type customer_category_code_list is Table of as_sales_credits_denorm.customer_category_code%type Index by Binary_integer;
42: Type sales_stage_list is Table of as_sales_credits_denorm.sales_stage%type Index by Binary_integer;
43: Type status_list is Table of as_sales_credits_denorm.status%type Index by Binary_integer;
44: Type last_name_list is Table of as_sales_credits_denorm.last_name%type Index by Binary_integer;
45: Type first_name_list is Table of as_sales_credits_denorm.first_name%type Index by Binary_integer;
46: Type interest_type_list is Table of as_sales_credits_denorm.interest_type%type Index by Binary_integer;

Line 43: Type status_list is Table of as_sales_credits_denorm.status%type Index by Binary_integer;

39: Type owner_group_name_list is Table of as_sales_credits_denorm.owner_group_name%type Index by Binary_integer;
40: Type customer_category_list is Table of as_sales_credits_denorm.customer_category%type Index by Binary_integer;
41: Type customer_category_code_list is Table of as_sales_credits_denorm.customer_category_code%type Index by Binary_integer;
42: Type sales_stage_list is Table of as_sales_credits_denorm.sales_stage%type Index by Binary_integer;
43: Type status_list is Table of as_sales_credits_denorm.status%type Index by Binary_integer;
44: Type last_name_list is Table of as_sales_credits_denorm.last_name%type Index by Binary_integer;
45: Type first_name_list is Table of as_sales_credits_denorm.first_name%type Index by Binary_integer;
46: Type interest_type_list is Table of as_sales_credits_denorm.interest_type%type Index by Binary_integer;
47: Type primary_interest_code_list is Table of as_sales_credits_denorm.primary_interest_code%type Index by Binary_integer;

Line 44: Type last_name_list is Table of as_sales_credits_denorm.last_name%type Index by Binary_integer;

40: Type customer_category_list is Table of as_sales_credits_denorm.customer_category%type Index by Binary_integer;
41: Type customer_category_code_list is Table of as_sales_credits_denorm.customer_category_code%type Index by Binary_integer;
42: Type sales_stage_list is Table of as_sales_credits_denorm.sales_stage%type Index by Binary_integer;
43: Type status_list is Table of as_sales_credits_denorm.status%type Index by Binary_integer;
44: Type last_name_list is Table of as_sales_credits_denorm.last_name%type Index by Binary_integer;
45: Type first_name_list is Table of as_sales_credits_denorm.first_name%type Index by Binary_integer;
46: Type interest_type_list is Table of as_sales_credits_denorm.interest_type%type Index by Binary_integer;
47: Type primary_interest_code_list is Table of as_sales_credits_denorm.primary_interest_code%type Index by Binary_integer;
48: Type secondary_interest_code_list is Table of as_sales_credits_denorm.secondary_interest_code%type Index by Binary_integer;

Line 45: Type first_name_list is Table of as_sales_credits_denorm.first_name%type Index by Binary_integer;

41: Type customer_category_code_list is Table of as_sales_credits_denorm.customer_category_code%type Index by Binary_integer;
42: Type sales_stage_list is Table of as_sales_credits_denorm.sales_stage%type Index by Binary_integer;
43: Type status_list is Table of as_sales_credits_denorm.status%type Index by Binary_integer;
44: Type last_name_list is Table of as_sales_credits_denorm.last_name%type Index by Binary_integer;
45: Type first_name_list is Table of as_sales_credits_denorm.first_name%type Index by Binary_integer;
46: Type interest_type_list is Table of as_sales_credits_denorm.interest_type%type Index by Binary_integer;
47: Type primary_interest_code_list is Table of as_sales_credits_denorm.primary_interest_code%type Index by Binary_integer;
48: Type secondary_interest_code_list is Table of as_sales_credits_denorm.secondary_interest_code%type Index by Binary_integer;
49: Type uom_description_list is Table of as_sales_credits_denorm.uom_description%type Index by Binary_integer;

Line 46: Type interest_type_list is Table of as_sales_credits_denorm.interest_type%type Index by Binary_integer;

42: Type sales_stage_list is Table of as_sales_credits_denorm.sales_stage%type Index by Binary_integer;
43: Type status_list is Table of as_sales_credits_denorm.status%type Index by Binary_integer;
44: Type last_name_list is Table of as_sales_credits_denorm.last_name%type Index by Binary_integer;
45: Type first_name_list is Table of as_sales_credits_denorm.first_name%type Index by Binary_integer;
46: Type interest_type_list is Table of as_sales_credits_denorm.interest_type%type Index by Binary_integer;
47: Type primary_interest_code_list is Table of as_sales_credits_denorm.primary_interest_code%type Index by Binary_integer;
48: Type secondary_interest_code_list is Table of as_sales_credits_denorm.secondary_interest_code%type Index by Binary_integer;
49: Type uom_description_list is Table of as_sales_credits_denorm.uom_description%type Index by Binary_integer;
50: Type item_description_list is Table of as_sales_credits_denorm.item_description%type Index by Binary_integer;

Line 47: Type primary_interest_code_list is Table of as_sales_credits_denorm.primary_interest_code%type Index by Binary_integer;

43: Type status_list is Table of as_sales_credits_denorm.status%type Index by Binary_integer;
44: Type last_name_list is Table of as_sales_credits_denorm.last_name%type Index by Binary_integer;
45: Type first_name_list is Table of as_sales_credits_denorm.first_name%type Index by Binary_integer;
46: Type interest_type_list is Table of as_sales_credits_denorm.interest_type%type Index by Binary_integer;
47: Type primary_interest_code_list is Table of as_sales_credits_denorm.primary_interest_code%type Index by Binary_integer;
48: Type secondary_interest_code_list is Table of as_sales_credits_denorm.secondary_interest_code%type Index by Binary_integer;
49: Type uom_description_list is Table of as_sales_credits_denorm.uom_description%type Index by Binary_integer;
50: Type item_description_list is Table of as_sales_credits_denorm.item_description%type Index by Binary_integer;
51: Type party_type_list is Table of as_sales_credits_denorm.party_type%type Index by Binary_integer;

Line 48: Type secondary_interest_code_list is Table of as_sales_credits_denorm.secondary_interest_code%type Index by Binary_integer;

44: Type last_name_list is Table of as_sales_credits_denorm.last_name%type Index by Binary_integer;
45: Type first_name_list is Table of as_sales_credits_denorm.first_name%type Index by Binary_integer;
46: Type interest_type_list is Table of as_sales_credits_denorm.interest_type%type Index by Binary_integer;
47: Type primary_interest_code_list is Table of as_sales_credits_denorm.primary_interest_code%type Index by Binary_integer;
48: Type secondary_interest_code_list is Table of as_sales_credits_denorm.secondary_interest_code%type Index by Binary_integer;
49: Type uom_description_list is Table of as_sales_credits_denorm.uom_description%type Index by Binary_integer;
50: Type item_description_list is Table of as_sales_credits_denorm.item_description%type Index by Binary_integer;
51: Type party_type_list is Table of as_sales_credits_denorm.party_type%type Index by Binary_integer;
52: Type partner_cust_name_list is Table of as_sales_credits_denorm.partner_customer_name%type Index by Binary_integer;

Line 49: Type uom_description_list is Table of as_sales_credits_denorm.uom_description%type Index by Binary_integer;

45: Type first_name_list is Table of as_sales_credits_denorm.first_name%type Index by Binary_integer;
46: Type interest_type_list is Table of as_sales_credits_denorm.interest_type%type Index by Binary_integer;
47: Type primary_interest_code_list is Table of as_sales_credits_denorm.primary_interest_code%type Index by Binary_integer;
48: Type secondary_interest_code_list is Table of as_sales_credits_denorm.secondary_interest_code%type Index by Binary_integer;
49: Type uom_description_list is Table of as_sales_credits_denorm.uom_description%type Index by Binary_integer;
50: Type item_description_list is Table of as_sales_credits_denorm.item_description%type Index by Binary_integer;
51: Type party_type_list is Table of as_sales_credits_denorm.party_type%type Index by Binary_integer;
52: Type partner_cust_name_list is Table of as_sales_credits_denorm.partner_customer_name%type Index by Binary_integer;
53: Type opp_created_name_list is Table of as_sales_credits_denorm.opportunity_created_name%type Index by Binary_integer;

Line 50: Type item_description_list is Table of as_sales_credits_denorm.item_description%type Index by Binary_integer;

46: Type interest_type_list is Table of as_sales_credits_denorm.interest_type%type Index by Binary_integer;
47: Type primary_interest_code_list is Table of as_sales_credits_denorm.primary_interest_code%type Index by Binary_integer;
48: Type secondary_interest_code_list is Table of as_sales_credits_denorm.secondary_interest_code%type Index by Binary_integer;
49: Type uom_description_list is Table of as_sales_credits_denorm.uom_description%type Index by Binary_integer;
50: Type item_description_list is Table of as_sales_credits_denorm.item_description%type Index by Binary_integer;
51: Type party_type_list is Table of as_sales_credits_denorm.party_type%type Index by Binary_integer;
52: Type partner_cust_name_list is Table of as_sales_credits_denorm.partner_customer_name%type Index by Binary_integer;
53: Type opp_created_name_list is Table of as_sales_credits_denorm.opportunity_created_name%type Index by Binary_integer;
54: Type opp_last_upd_name_list is Table of as_sales_credits_denorm.opportunity_last_updated_name%type Index by Binary_integer;

Line 51: Type party_type_list is Table of as_sales_credits_denorm.party_type%type Index by Binary_integer;

47: Type primary_interest_code_list is Table of as_sales_credits_denorm.primary_interest_code%type Index by Binary_integer;
48: Type secondary_interest_code_list is Table of as_sales_credits_denorm.secondary_interest_code%type Index by Binary_integer;
49: Type uom_description_list is Table of as_sales_credits_denorm.uom_description%type Index by Binary_integer;
50: Type item_description_list is Table of as_sales_credits_denorm.item_description%type Index by Binary_integer;
51: Type party_type_list is Table of as_sales_credits_denorm.party_type%type Index by Binary_integer;
52: Type partner_cust_name_list is Table of as_sales_credits_denorm.partner_customer_name%type Index by Binary_integer;
53: Type opp_created_name_list is Table of as_sales_credits_denorm.opportunity_created_name%type Index by Binary_integer;
54: Type opp_last_upd_name_list is Table of as_sales_credits_denorm.opportunity_last_updated_name%type Index by Binary_integer;
55: Type close_reason_men_list is Table of Varchar2(80) Index by Binary_integer;

Line 52: Type partner_cust_name_list is Table of as_sales_credits_denorm.partner_customer_name%type Index by Binary_integer;

48: Type secondary_interest_code_list is Table of as_sales_credits_denorm.secondary_interest_code%type Index by Binary_integer;
49: Type uom_description_list is Table of as_sales_credits_denorm.uom_description%type Index by Binary_integer;
50: Type item_description_list is Table of as_sales_credits_denorm.item_description%type Index by Binary_integer;
51: Type party_type_list is Table of as_sales_credits_denorm.party_type%type Index by Binary_integer;
52: Type partner_cust_name_list is Table of as_sales_credits_denorm.partner_customer_name%type Index by Binary_integer;
53: Type opp_created_name_list is Table of as_sales_credits_denorm.opportunity_created_name%type Index by Binary_integer;
54: Type opp_last_upd_name_list is Table of as_sales_credits_denorm.opportunity_last_updated_name%type Index by Binary_integer;
55: Type close_reason_men_list is Table of Varchar2(80) Index by Binary_integer;
56: Type business_group_name_list is Table of Varchar2(60) Index by Binary_integer;

Line 53: Type opp_created_name_list is Table of as_sales_credits_denorm.opportunity_created_name%type Index by Binary_integer;

49: Type uom_description_list is Table of as_sales_credits_denorm.uom_description%type Index by Binary_integer;
50: Type item_description_list is Table of as_sales_credits_denorm.item_description%type Index by Binary_integer;
51: Type party_type_list is Table of as_sales_credits_denorm.party_type%type Index by Binary_integer;
52: Type partner_cust_name_list is Table of as_sales_credits_denorm.partner_customer_name%type Index by Binary_integer;
53: Type opp_created_name_list is Table of as_sales_credits_denorm.opportunity_created_name%type Index by Binary_integer;
54: Type opp_last_upd_name_list is Table of as_sales_credits_denorm.opportunity_last_updated_name%type Index by Binary_integer;
55: Type close_reason_men_list is Table of Varchar2(80) Index by Binary_integer;
56: Type business_group_name_list is Table of Varchar2(60) Index by Binary_integer;
57: Type close_reason_list is Table of as_leads_all.close_reason%type Index by Binary_integer;

Line 54: Type opp_last_upd_name_list is Table of as_sales_credits_denorm.opportunity_last_updated_name%type Index by Binary_integer;

50: Type item_description_list is Table of as_sales_credits_denorm.item_description%type Index by Binary_integer;
51: Type party_type_list is Table of as_sales_credits_denorm.party_type%type Index by Binary_integer;
52: Type partner_cust_name_list is Table of as_sales_credits_denorm.partner_customer_name%type Index by Binary_integer;
53: Type opp_created_name_list is Table of as_sales_credits_denorm.opportunity_created_name%type Index by Binary_integer;
54: Type opp_last_upd_name_list is Table of as_sales_credits_denorm.opportunity_last_updated_name%type Index by Binary_integer;
55: Type close_reason_men_list is Table of Varchar2(80) Index by Binary_integer;
56: Type business_group_name_list is Table of Varchar2(60) Index by Binary_integer;
57: Type close_reason_list is Table of as_leads_all.close_reason%type Index by Binary_integer;
58: Type rolling_frcst_flg_list is Table of as_sales_credits_denorm.rolling_forecast_flag%type Index by Binary_integer;

Line 58: Type rolling_frcst_flg_list is Table of as_sales_credits_denorm.rolling_forecast_flag%type Index by Binary_integer;

54: Type opp_last_upd_name_list is Table of as_sales_credits_denorm.opportunity_last_updated_name%type Index by Binary_integer;
55: Type close_reason_men_list is Table of Varchar2(80) Index by Binary_integer;
56: Type business_group_name_list is Table of Varchar2(60) Index by Binary_integer;
57: Type close_reason_list is Table of as_leads_all.close_reason%type Index by Binary_integer;
58: Type rolling_frcst_flg_list is Table of as_sales_credits_denorm.rolling_forecast_flag%type Index by Binary_integer;
59: Type frcst_date_list is Table of as_sales_credits_denorm.forecast_date%type Index by Binary_integer;
60: Type opp_creation_date_list is Table of as_leads_all.creation_date%type Index by Binary_integer;
61: Type opp_created_by_list is Table of as_leads_all.created_by%type Index by Binary_integer;
62: Type attribute_category_list is Table of Varchar2(30) Index by Binary_integer;

Line 59: Type frcst_date_list is Table of as_sales_credits_denorm.forecast_date%type Index by Binary_integer;

55: Type close_reason_men_list is Table of Varchar2(80) Index by Binary_integer;
56: Type business_group_name_list is Table of Varchar2(60) Index by Binary_integer;
57: Type close_reason_list is Table of as_leads_all.close_reason%type Index by Binary_integer;
58: Type rolling_frcst_flg_list is Table of as_sales_credits_denorm.rolling_forecast_flag%type Index by Binary_integer;
59: Type frcst_date_list is Table of as_sales_credits_denorm.forecast_date%type Index by Binary_integer;
60: Type opp_creation_date_list is Table of as_leads_all.creation_date%type Index by Binary_integer;
61: Type opp_created_by_list is Table of as_leads_all.created_by%type Index by Binary_integer;
62: Type attribute_category_list is Table of Varchar2(30) Index by Binary_integer;
63: Type attribute_list is Table of Varchar2(150) Index by Binary_integer;