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_STL_BALANCES

Line 34: PROCEDURE transfer_balance( pn_settlement_id IN jai_rgm_stl_balances.settlement_id%TYPE,

30: -- # 115.2 4245365 4245089 Rchandan 17/03/2005 Changes were made to implement VAT. Two new procedures are added to this package
31: -- # --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
32: -- # ****************************************************************************************************************************************************************************************
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:

Line 46: pn_org_id IN jai_rgm_stl_balances.party_id%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,
50: pn_last_updated_by IN ap_invoices_interface.last_updated_by%TYPE,

Line 57: FUNCTION get_last_settlement_date(pn_org_id IN jai_rgm_stl_balances.party_id%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,
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: )

Line 64: PROCEDURE get_last_balance_amount(pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,

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,
65: pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,
66: pn_debit_amount OUT NOCOPY jai_rgm_stl_balances.debit_balance%TYPE,
67: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE);
68:

Line 65: pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,

61: )
62: RETURN DATE;
63:
64: PROCEDURE get_last_balance_amount(pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
65: pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,
66: pn_debit_amount OUT NOCOPY jai_rgm_stl_balances.debit_balance%TYPE,
67: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE);
68:
69: PROCEDURE register_entry( pn_regime_id IN NUMBER,

Line 66: pn_debit_amount OUT NOCOPY jai_rgm_stl_balances.debit_balance%TYPE,

62: RETURN DATE;
63:
64: PROCEDURE get_last_balance_amount(pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
65: pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,
66: pn_debit_amount OUT NOCOPY jai_rgm_stl_balances.debit_balance%TYPE,
67: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE);
68:
69: PROCEDURE register_entry( pn_regime_id IN NUMBER,
70: pn_settlement_id IN NUMBER,

Line 67: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE);

63:
64: PROCEDURE get_last_balance_amount(pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
65: pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,
66: pn_debit_amount OUT NOCOPY jai_rgm_stl_balances.debit_balance%TYPE,
67: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE);
68:
69: PROCEDURE register_entry( pn_regime_id IN NUMBER,
70: pn_settlement_id IN NUMBER,
71: pd_transaction_date IN DATE,

Line 76: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,

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
80:

Line 77: pn_location_id IN jai_rgm_stl_balances.location_id%TYPE,

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
80:
81: /*

Line 93: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,

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,
97: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE,

Line 94: pn_location_id IN jai_rgm_stl_balances.location_id%TYPE,

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,
97: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE,
98: pv_service_type_code IN jai_rgm_stl_balances.service_type_code%TYPE DEFAULT NULL /* added by ssawant for bug 5879769 */

Line 95: pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,

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,
97: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE,
98: pv_service_type_code IN jai_rgm_stl_balances.service_type_code%TYPE DEFAULT NULL /* added by ssawant for bug 5879769 */
99: ); ---4245365

Line 96: pn_debit_amount OUT NOCOPY jai_rgm_stl_balances.debit_balance%TYPE,

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,
97: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE,
98: pv_service_type_code IN jai_rgm_stl_balances.service_type_code%TYPE DEFAULT NULL /* added by ssawant for bug 5879769 */
99: ); ---4245365
100:

Line 97: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%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,
97: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE,
98: pv_service_type_code IN jai_rgm_stl_balances.service_type_code%TYPE DEFAULT NULL /* added by ssawant for bug 5879769 */
99: ); ---4245365
100:
101: END jai_cmn_rgm_settlement_pkg;

Line 98: pv_service_type_code IN jai_rgm_stl_balances.service_type_code%TYPE DEFAULT NULL /* added by ssawant for bug 5879769 */

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,
97: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE,
98: pv_service_type_code IN jai_rgm_stl_balances.service_type_code%TYPE DEFAULT NULL /* added by ssawant for bug 5879769 */
99: ); ---4245365
100:
101: END jai_cmn_rgm_settlement_pkg;