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.JAI_CMN_RGM_SETTLEMENT_PKG dependencies on JAI_RGM_SETTLEMENTS

Line 37: pv_reverse_charge_flag IN jai_rgm_settlements.reverse_charge_flag%TYPE DEFAULT NULL);--Added by Qiong for reverse charge settlement

33:
34: PROCEDURE transfer_balance( pn_settlement_id IN jai_rgm_stl_balances.settlement_id%TYPE,
35: pv_process_flag OUT NOCOPY VARCHAR2,
36: pv_process_message OUT NOCOPY VARCHAR2,
37: pv_reverse_charge_flag IN jai_rgm_settlements.reverse_charge_flag%TYPE DEFAULT NULL);--Added by Qiong for reverse charge settlement
38:
39: PROCEDURE create_invoice( pn_regime_id IN jai_rgm_settlements.regime_id%TYPE,
40: pn_settlement_id IN jai_rgm_settlements.settlement_id%TYPE,
41: pd_settlement_date IN jai_rgm_settlements.settlement_date%TYPE,

Line 39: PROCEDURE create_invoice( pn_regime_id IN jai_rgm_settlements.regime_id%TYPE,

35: pv_process_flag OUT NOCOPY VARCHAR2,
36: pv_process_message OUT NOCOPY VARCHAR2,
37: pv_reverse_charge_flag IN jai_rgm_settlements.reverse_charge_flag%TYPE DEFAULT NULL);--Added by Qiong for reverse charge settlement
38:
39: PROCEDURE create_invoice( pn_regime_id IN jai_rgm_settlements.regime_id%TYPE,
40: pn_settlement_id IN jai_rgm_settlements.settlement_id%TYPE,
41: pd_settlement_date IN jai_rgm_settlements.settlement_date%TYPE,
42: pn_vendor_id IN jai_rgm_settlements.tax_authority_id%TYPE,
43: pn_vendor_site_id IN jai_rgm_settlements.tax_authority_site_id%TYPE,

Line 40: pn_settlement_id IN jai_rgm_settlements.settlement_id%TYPE,

36: pv_process_message OUT NOCOPY VARCHAR2,
37: pv_reverse_charge_flag IN jai_rgm_settlements.reverse_charge_flag%TYPE DEFAULT NULL);--Added by Qiong for reverse charge settlement
38:
39: PROCEDURE create_invoice( pn_regime_id IN jai_rgm_settlements.regime_id%TYPE,
40: pn_settlement_id IN jai_rgm_settlements.settlement_id%TYPE,
41: pd_settlement_date IN jai_rgm_settlements.settlement_date%TYPE,
42: pn_vendor_id IN jai_rgm_settlements.tax_authority_id%TYPE,
43: pn_vendor_site_id IN jai_rgm_settlements.tax_authority_site_id%TYPE,
44: pn_calculated_amount IN jai_rgm_settlements.calculated_amount%TYPE,

Line 41: pd_settlement_date IN jai_rgm_settlements.settlement_date%TYPE,

37: pv_reverse_charge_flag IN jai_rgm_settlements.reverse_charge_flag%TYPE DEFAULT NULL);--Added by Qiong for reverse charge settlement
38:
39: PROCEDURE create_invoice( pn_regime_id IN jai_rgm_settlements.regime_id%TYPE,
40: pn_settlement_id IN jai_rgm_settlements.settlement_id%TYPE,
41: pd_settlement_date IN jai_rgm_settlements.settlement_date%TYPE,
42: pn_vendor_id IN jai_rgm_settlements.tax_authority_id%TYPE,
43: pn_vendor_site_id IN jai_rgm_settlements.tax_authority_site_id%TYPE,
44: pn_calculated_amount IN jai_rgm_settlements.calculated_amount%TYPE,
45: pn_invoice_amount IN jai_rgm_settlements.payment_amount%TYPE,

Line 42: pn_vendor_id IN jai_rgm_settlements.tax_authority_id%TYPE,

38:
39: PROCEDURE create_invoice( pn_regime_id IN jai_rgm_settlements.regime_id%TYPE,
40: pn_settlement_id IN jai_rgm_settlements.settlement_id%TYPE,
41: pd_settlement_date IN jai_rgm_settlements.settlement_date%TYPE,
42: pn_vendor_id IN jai_rgm_settlements.tax_authority_id%TYPE,
43: pn_vendor_site_id IN jai_rgm_settlements.tax_authority_site_id%TYPE,
44: pn_calculated_amount IN jai_rgm_settlements.calculated_amount%TYPE,
45: pn_invoice_amount IN jai_rgm_settlements.payment_amount%TYPE,
46: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,

Line 43: pn_vendor_site_id IN jai_rgm_settlements.tax_authority_site_id%TYPE,

39: PROCEDURE create_invoice( pn_regime_id IN jai_rgm_settlements.regime_id%TYPE,
40: pn_settlement_id IN jai_rgm_settlements.settlement_id%TYPE,
41: pd_settlement_date IN jai_rgm_settlements.settlement_date%TYPE,
42: pn_vendor_id IN jai_rgm_settlements.tax_authority_id%TYPE,
43: pn_vendor_site_id IN jai_rgm_settlements.tax_authority_site_id%TYPE,
44: pn_calculated_amount IN jai_rgm_settlements.calculated_amount%TYPE,
45: pn_invoice_amount IN jai_rgm_settlements.payment_amount%TYPE,
46: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
47: pv_regsitration_no IN jai_rgm_settlements.primary_registration_no%TYPE,

Line 44: pn_calculated_amount IN jai_rgm_settlements.calculated_amount%TYPE,

40: pn_settlement_id IN jai_rgm_settlements.settlement_id%TYPE,
41: pd_settlement_date IN jai_rgm_settlements.settlement_date%TYPE,
42: pn_vendor_id IN jai_rgm_settlements.tax_authority_id%TYPE,
43: pn_vendor_site_id IN jai_rgm_settlements.tax_authority_site_id%TYPE,
44: pn_calculated_amount IN jai_rgm_settlements.calculated_amount%TYPE,
45: pn_invoice_amount IN jai_rgm_settlements.payment_amount%TYPE,
46: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
47: pv_regsitration_no IN jai_rgm_settlements.primary_registration_no%TYPE,
48: pn_created_by IN ap_invoices_interface.created_by%TYPE,

Line 45: pn_invoice_amount IN jai_rgm_settlements.payment_amount%TYPE,

41: pd_settlement_date IN jai_rgm_settlements.settlement_date%TYPE,
42: pn_vendor_id IN jai_rgm_settlements.tax_authority_id%TYPE,
43: pn_vendor_site_id IN jai_rgm_settlements.tax_authority_site_id%TYPE,
44: pn_calculated_amount IN jai_rgm_settlements.calculated_amount%TYPE,
45: pn_invoice_amount IN jai_rgm_settlements.payment_amount%TYPE,
46: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
47: pv_regsitration_no IN jai_rgm_settlements.primary_registration_no%TYPE,
48: pn_created_by IN ap_invoices_interface.created_by%TYPE,
49: pd_creation_date IN ap_invoices_interface.creation_date%TYPE,

Line 47: pv_regsitration_no IN jai_rgm_settlements.primary_registration_no%TYPE,

43: pn_vendor_site_id IN jai_rgm_settlements.tax_authority_site_id%TYPE,
44: pn_calculated_amount IN jai_rgm_settlements.calculated_amount%TYPE,
45: pn_invoice_amount IN jai_rgm_settlements.payment_amount%TYPE,
46: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
47: pv_regsitration_no IN jai_rgm_settlements.primary_registration_no%TYPE,
48: pn_created_by IN ap_invoices_interface.created_by%TYPE,
49: pd_creation_date IN ap_invoices_interface.creation_date%TYPE,
50: pn_last_updated_by IN ap_invoices_interface.last_updated_by%TYPE,
51: pd_last_update_date IN ap_invoices_interface.last_update_date%TYPE,

Line 53: pv_system_invoice_no OUT NOCOPY jai_rgm_settlements.system_invoice_no%TYPE,

49: pd_creation_date IN ap_invoices_interface.creation_date%TYPE,
50: pn_last_updated_by IN ap_invoices_interface.last_updated_by%TYPE,
51: pd_last_update_date IN ap_invoices_interface.last_update_date%TYPE,
52: pn_last_update_login IN ap_invoices_interface.last_update_login%TYPE,
53: pv_system_invoice_no OUT NOCOPY jai_rgm_settlements.system_invoice_no%TYPE,
54: pv_process_flag OUT NOCOPY VARCHAR2,
55: pv_process_message OUT NOCOPY VARCHAR2);
56:
57: FUNCTION get_last_settlement_date(pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,

Line 59: pn_regime_id IN jai_rgm_settlements.regime_id%TYPE DEFAULT NULL,

55: pv_process_message OUT NOCOPY VARCHAR2);
56:
57: FUNCTION get_last_settlement_date(pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
58: /* Bug 5096787. Added by Lakshmi Gopalsami */
59: pn_regime_id IN jai_rgm_settlements.regime_id%TYPE DEFAULT NULL,
60: pv_reverse_charge_flag IN jai_rgm_settlements.reverse_charge_flag%TYPE DEFAULT NULL--Added by Qiong for reverse charge settlement
61: )
62: RETURN DATE;
63:

Line 60: pv_reverse_charge_flag IN jai_rgm_settlements.reverse_charge_flag%TYPE DEFAULT NULL--Added by Qiong for reverse charge settlement

56:
57: FUNCTION get_last_settlement_date(pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
58: /* Bug 5096787. Added by Lakshmi Gopalsami */
59: pn_regime_id IN jai_rgm_settlements.regime_id%TYPE DEFAULT NULL,
60: pv_reverse_charge_flag IN jai_rgm_settlements.reverse_charge_flag%TYPE DEFAULT NULL--Added by Qiong for reverse charge settlement
61: )
62: RETURN DATE;
63:
64: PROCEDURE get_last_balance_amount(pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,

Line 75: FUNCTION get_last_settlement_date(pn_regime_id IN jai_rgm_settlements.regime_id%type,

71: pd_transaction_date IN DATE,
72: pv_process_flag OUT NOCOPY VARCHAR2,
73: pv_process_message OUT NOCOPY VARCHAR2);
74:
75: FUNCTION get_last_settlement_date(pn_regime_id IN jai_rgm_settlements.regime_id%type,
76: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
77: pn_location_id IN jai_rgm_stl_balances.location_id%TYPE,
78: pv_reverse_charge_flag IN jai_rgm_settlements.reverse_charge_flag%type DEFAULT NULL)
79: RETURN DATE; ---4245365

Line 78: pv_reverse_charge_flag IN jai_rgm_settlements.reverse_charge_flag%type DEFAULT NULL)

74:
75: FUNCTION get_last_settlement_date(pn_regime_id IN jai_rgm_settlements.regime_id%type,
76: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
77: pn_location_id IN jai_rgm_stl_balances.location_id%TYPE,
78: pv_reverse_charge_flag IN jai_rgm_settlements.reverse_charge_flag%type DEFAULT NULL)
79: RETURN DATE; ---4245365
80:
81: /*
82: ||The following function addded by rchandan for bug#6835541

Line 92: PROCEDURE get_last_balance_amount(pn_regime_id IN jai_rgm_settlements.regime_id%type,

88: pn_organization_id IN NUMBER,
89: pn_location_id IN NUMBER)
90: RETURN DATE;
91:
92: PROCEDURE get_last_balance_amount(pn_regime_id IN jai_rgm_settlements.regime_id%type,
93: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
94: pn_location_id IN jai_rgm_stl_balances.location_id%TYPE,
95: pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,
96: pn_debit_amount OUT NOCOPY jai_rgm_stl_balances.debit_balance%TYPE,