DBA Data[Home] [Help]

APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_RGM_THRESHOLDS

Line 19: p_regime_id - A valid regime_id from jai_rgm_thresholds.

15:
16: ----------------------------------------------------------------------------
17: get_threshold_slab_id - returns identifier for current threshold slab as out parameter
18: IN
19: p_regime_id - A valid regime_id from jai_rgm_thresholds.
20: p_org_tan_no - Organiztion TAN as defined in the regime setup
21: p_organization_id - Inventory organization defined in the regime setup
22: p_party_type - Party type. Can be either CUSTOMER or VENDOR. Currently only CUSTOMER is valid.
23: p_party_id - Party identifier.

Line 41: p_regime_id in jai_rgm_thresholds.regime_id%type

37: */
38:
39: procedure get_threshold_slab_id
40: (
41: p_regime_id in jai_rgm_thresholds.regime_id%type
42: , p_org_tan_no in JAI_RGM_REGISTRATIONS.attribute_value%type default null
43: , p_organization_id in hr_organization_units.organization_id%type default null
44: , p_party_type in jai_rgm_thresholds.party_type%type
45: , p_party_id in jai_rgm_thresholds.party_id%type

Line 44: , p_party_type in jai_rgm_thresholds.party_type%type

40: (
41: p_regime_id in jai_rgm_thresholds.regime_id%type
42: , p_org_tan_no in JAI_RGM_REGISTRATIONS.attribute_value%type default null
43: , p_organization_id in hr_organization_units.organization_id%type default null
44: , p_party_type in jai_rgm_thresholds.party_type%type
45: , p_party_id in jai_rgm_thresholds.party_id%type
46: , p_fin_year in jai_rgm_thresholds.fin_year%type default null
47: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type default null
48: , p_source_trx_date in date default null

Line 45: , p_party_id in jai_rgm_thresholds.party_id%type

41: p_regime_id in jai_rgm_thresholds.regime_id%type
42: , p_org_tan_no in JAI_RGM_REGISTRATIONS.attribute_value%type default null
43: , p_organization_id in hr_organization_units.organization_id%type default null
44: , p_party_type in jai_rgm_thresholds.party_type%type
45: , p_party_id in jai_rgm_thresholds.party_id%type
46: , p_fin_year in jai_rgm_thresholds.fin_year%type default null
47: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type default null
48: , p_source_trx_date in date default null
49: , p_called_from in varchar2 default null

Line 46: , p_fin_year in jai_rgm_thresholds.fin_year%type default null

42: , p_org_tan_no in JAI_RGM_REGISTRATIONS.attribute_value%type default null
43: , p_organization_id in hr_organization_units.organization_id%type default null
44: , p_party_type in jai_rgm_thresholds.party_type%type
45: , p_party_id in jai_rgm_thresholds.party_id%type
46: , p_fin_year in jai_rgm_thresholds.fin_year%type default null
47: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type default null
48: , p_source_trx_date in date default null
49: , p_called_from in varchar2 default null
50: , p_threshold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type

Line 50: , p_threshold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type

46: , p_fin_year in jai_rgm_thresholds.fin_year%type default null
47: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type default null
48: , p_source_trx_date in date default null
49: , p_called_from in varchar2 default null
50: , p_threshold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type
51: , p_process_flag out nocopy varchar2
52: , p_process_message out nocopy varchar2
53: );
54: /*

Line 70: p_threshold_slab_id in jai_rgm_thresholds.threshold_slab_id%type

66: */
67:
68: procedure get_threshold_tax_cat_id
69: (
70: p_threshold_slab_id in jai_rgm_thresholds.threshold_slab_id%type
71: , p_org_id in jai_ap_tds_thhold_taxes.operating_unit_id%type
72: , p_threshold_tax_cat_id out nocopy jai_ap_tds_thhold_taxes.tax_category_id%type
73: , p_process_flag out nocopy varchar2
74: , p_process_message out nocopy varchar2

Line 130: ( p_record in jai_rgm_thresholds%rowtype

126: , p_row_id out nocopy rowid
127: ) ;
128:
129: procedure insert_threshold_hdr
130: ( p_record in jai_rgm_thresholds%rowtype
131: , p_threshold_id out nocopy jai_rgm_thresholds.threshold_id%type
132: , p_row_id out nocopy rowid
133: );
134:

Line 131: , p_threshold_id out nocopy jai_rgm_thresholds.threshold_id%type

127: ) ;
128:
129: procedure insert_threshold_hdr
130: ( p_record in jai_rgm_thresholds%rowtype
131: , p_threshold_id out nocopy jai_rgm_thresholds.threshold_id%type
132: , p_row_id out nocopy rowid
133: );
134:
135: procedure sync_threshold_header

Line 136: ( p_threshold_id in jai_rgm_thresholds.threshold_id%type

132: , p_row_id out nocopy rowid
133: );
134:
135: procedure sync_threshold_header
136: ( p_threshold_id in jai_rgm_thresholds.threshold_id%type
137: , p_source_trx_date in date
138: , p_thhold_slab_change_flag out nocopy varchar2
139: , p_new_thhold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type
140: , p_process_flag out nocopy varchar2

Line 139: , p_new_thhold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type

135: procedure sync_threshold_header
136: ( p_threshold_id in jai_rgm_thresholds.threshold_id%type
137: , p_source_trx_date in date
138: , p_thhold_slab_change_flag out nocopy varchar2
139: , p_new_thhold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type
140: , p_process_flag out nocopy varchar2
141: , p_process_message out nocopy varchar2
142: ) ;
143: