DBA Data[Home] [Help]

APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_RGM_THRESHOLDS

Line 22: p_regime_id - A valid regime_id from jai_rgm_thresholds.

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

Line 44: p_regime_id in jai_rgm_thresholds.regime_id%type

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

Line 47: , p_party_type in jai_rgm_thresholds.party_type%type

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

Line 48: , p_party_id in jai_rgm_thresholds.party_id%type

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

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

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

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

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

Line 73: p_threshold_slab_id in jai_rgm_thresholds.threshold_slab_id%type

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

Line 135: ( p_record in jai_rgm_thresholds%rowtype

131: , p_row_id out nocopy rowid
132: ) ;
133:
134: procedure insert_threshold_hdr
135: ( p_record in jai_rgm_thresholds%rowtype
136: , p_threshold_id out nocopy jai_rgm_thresholds.threshold_id%type
137: , p_row_id out nocopy rowid
138: );
139:

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

132: ) ;
133:
134: procedure insert_threshold_hdr
135: ( p_record in jai_rgm_thresholds%rowtype
136: , p_threshold_id out nocopy jai_rgm_thresholds.threshold_id%type
137: , p_row_id out nocopy rowid
138: );
139:
140: procedure sync_threshold_header

Line 141: ( p_threshold_id in jai_rgm_thresholds.threshold_id%type

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

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

140: procedure sync_threshold_header
141: ( p_threshold_id in jai_rgm_thresholds.threshold_id%type
142: , p_source_trx_date in date
143: , p_thhold_slab_change_flag out nocopy varchar2
144: , p_new_thhold_slab_id out nocopy jai_rgm_thresholds.threshold_slab_id%type
145: , p_process_flag out nocopy varchar2
146: , p_process_message out nocopy varchar2
147: ) ;
148: