DBA Data[Home] [Help]

APPS.ARH_ARXCUDCI_PKG dependencies on STANDARD

Line 48: customer_type := arp_standard.ar_lookup('CUSTOMER_TYPE','R');

44: functional_currency in out NOCOPY varchar2
45: ) is
46:
47: begin
48: customer_type := arp_standard.ar_lookup('CUSTOMER_TYPE','R');
49:
50: tax_printing_option := arp_standard.sysparm.tax_invoice_print;
51:
52: begin

Line 50: tax_printing_option := arp_standard.sysparm.tax_invoice_print;

46:
47: begin
48: customer_type := arp_standard.ar_lookup('CUSTOMER_TYPE','R');
49:
50: tax_printing_option := arp_standard.sysparm.tax_invoice_print;
51:
52: begin
53: select gr.name
54: into grouping_rule

Line 56: where gr.grouping_rule_id = arp_standard.sysparm.default_grouping_rule_id

52: begin
53: select gr.name
54: into grouping_rule
55: from ra_grouping_rules gr
56: where gr.grouping_rule_id = arp_standard.sysparm.default_grouping_rule_id
57: and trunc(sysdate) BETWEEN gr.start_date AND nvl(gr.end_date, trunc(sysdate));
58: exception
59: when NO_DATA_FOUND then
60: null;

Line 63: --l_sob_id := arp_standard.sysparm.set_of_books_id;

59: when NO_DATA_FOUND then
60: null;
61: end;
62:
63: --l_sob_id := arp_standard.sysparm.set_of_books_id;
64: --
65: BEGIN
66: SELECT currency_code
67: INTO functional_currency

Line 69: WHERE set_of_books_id = arp_standard.sysparm.set_of_books_id;

65: BEGIN
66: SELECT currency_code
67: INTO functional_currency
68: FROM gl_sets_of_books
69: WHERE set_of_books_id = arp_standard.sysparm.set_of_books_id;
70: EXCEPTION
71: when NO_DATA_FOUND then
72: arp_standard.fnd_message( 'ARTA_SET_OF_BOOKS_ID_NOT_FOUND' );
73: END;

Line 72: arp_standard.fnd_message( 'ARTA_SET_OF_BOOKS_ID_NOT_FOUND' );

68: FROM gl_sets_of_books
69: WHERE set_of_books_id = arp_standard.sysparm.set_of_books_id;
70: EXCEPTION
71: when NO_DATA_FOUND then
72: arp_standard.fnd_message( 'ARTA_SET_OF_BOOKS_ID_NOT_FOUND' );
73: END;
74: --
75: create_reciprocal := arp_standard.sysparm.create_reciprocal_flag;
76: auto_cust_numbering := arp_standard.sysparm.generate_customer_number;

Line 75: create_reciprocal := arp_standard.sysparm.create_reciprocal_flag;

71: when NO_DATA_FOUND then
72: arp_standard.fnd_message( 'ARTA_SET_OF_BOOKS_ID_NOT_FOUND' );
73: END;
74: --
75: create_reciprocal := arp_standard.sysparm.create_reciprocal_flag;
76: auto_cust_numbering := arp_standard.sysparm.generate_customer_number;
77: auto_site_numbering := arp_standard.sysparm.auto_site_numbering;
78: address_validation := arp_standard.sysparm.address_validation;
79: location_structure_id := arp_standard.sysparm.location_structure_id;

Line 76: auto_cust_numbering := arp_standard.sysparm.generate_customer_number;

72: arp_standard.fnd_message( 'ARTA_SET_OF_BOOKS_ID_NOT_FOUND' );
73: END;
74: --
75: create_reciprocal := arp_standard.sysparm.create_reciprocal_flag;
76: auto_cust_numbering := arp_standard.sysparm.generate_customer_number;
77: auto_site_numbering := arp_standard.sysparm.auto_site_numbering;
78: address_validation := arp_standard.sysparm.address_validation;
79: location_structure_id := arp_standard.sysparm.location_structure_id;
80: from_postal_code := arp_standard.sysparm.from_postal_code;

Line 77: auto_site_numbering := arp_standard.sysparm.auto_site_numbering;

73: END;
74: --
75: create_reciprocal := arp_standard.sysparm.create_reciprocal_flag;
76: auto_cust_numbering := arp_standard.sysparm.generate_customer_number;
77: auto_site_numbering := arp_standard.sysparm.auto_site_numbering;
78: address_validation := arp_standard.sysparm.address_validation;
79: location_structure_id := arp_standard.sysparm.location_structure_id;
80: from_postal_code := arp_standard.sysparm.from_postal_code;
81: to_postal_code := arp_standard.sysparm.to_postal_code;

Line 78: address_validation := arp_standard.sysparm.address_validation;

74: --
75: create_reciprocal := arp_standard.sysparm.create_reciprocal_flag;
76: auto_cust_numbering := arp_standard.sysparm.generate_customer_number;
77: auto_site_numbering := arp_standard.sysparm.auto_site_numbering;
78: address_validation := arp_standard.sysparm.address_validation;
79: location_structure_id := arp_standard.sysparm.location_structure_id;
80: from_postal_code := arp_standard.sysparm.from_postal_code;
81: to_postal_code := arp_standard.sysparm.to_postal_code;
82: home_country_code := arp_standard.sysparm.default_country;

Line 79: location_structure_id := arp_standard.sysparm.location_structure_id;

75: create_reciprocal := arp_standard.sysparm.create_reciprocal_flag;
76: auto_cust_numbering := arp_standard.sysparm.generate_customer_number;
77: auto_site_numbering := arp_standard.sysparm.auto_site_numbering;
78: address_validation := arp_standard.sysparm.address_validation;
79: location_structure_id := arp_standard.sysparm.location_structure_id;
80: from_postal_code := arp_standard.sysparm.from_postal_code;
81: to_postal_code := arp_standard.sysparm.to_postal_code;
82: home_country_code := arp_standard.sysparm.default_country;
83: fnd_profile.get('DEFAULT_COUNTRY',default_country_code);

Line 80: from_postal_code := arp_standard.sysparm.from_postal_code;

76: auto_cust_numbering := arp_standard.sysparm.generate_customer_number;
77: auto_site_numbering := arp_standard.sysparm.auto_site_numbering;
78: address_validation := arp_standard.sysparm.address_validation;
79: location_structure_id := arp_standard.sysparm.location_structure_id;
80: from_postal_code := arp_standard.sysparm.from_postal_code;
81: to_postal_code := arp_standard.sysparm.to_postal_code;
82: home_country_code := arp_standard.sysparm.default_country;
83: fnd_profile.get('DEFAULT_COUNTRY',default_country_code);
84: --

Line 81: to_postal_code := arp_standard.sysparm.to_postal_code;

77: auto_site_numbering := arp_standard.sysparm.auto_site_numbering;
78: address_validation := arp_standard.sysparm.address_validation;
79: location_structure_id := arp_standard.sysparm.location_structure_id;
80: from_postal_code := arp_standard.sysparm.from_postal_code;
81: to_postal_code := arp_standard.sysparm.to_postal_code;
82: home_country_code := arp_standard.sysparm.default_country;
83: fnd_profile.get('DEFAULT_COUNTRY',default_country_code);
84: --
85: if ( default_country_code is null ) then

Line 82: home_country_code := arp_standard.sysparm.default_country;

78: address_validation := arp_standard.sysparm.address_validation;
79: location_structure_id := arp_standard.sysparm.location_structure_id;
80: from_postal_code := arp_standard.sysparm.from_postal_code;
81: to_postal_code := arp_standard.sysparm.to_postal_code;
82: home_country_code := arp_standard.sysparm.default_country;
83: fnd_profile.get('DEFAULT_COUNTRY',default_country_code);
84: --
85: if ( default_country_code is null ) then
86: default_country_code := home_country_code;