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 35: PROCEDURE transfer_balance( pn_settlement_id IN jai_rgm_stl_balances.settlement_id%TYPE,

31: -- # 115.2 4245365 4245089 Rchandan 17/03/2005 Changes were made to implement VAT. Two new procedures are added to this package
32: -- # --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
33: -- # ****************************************************************************************************************************************************************************************
34:
35: PROCEDURE transfer_balance( pn_settlement_id IN jai_rgm_stl_balances.settlement_id%TYPE,
36: pv_process_flag OUT NOCOPY VARCHAR2,
37: pv_process_message OUT NOCOPY VARCHAR2);
38:
39: PROCEDURE create_invoice( pn_regime_id IN jai_rgm_settlements.regime_id%TYPE,

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: )
61: RETURN DATE;

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

59: pn_regime_id IN jai_rgm_settlements.regime_id%TYPE DEFAULT NULL
60: )
61: RETURN DATE;
62:
63: PROCEDURE get_last_balance_amount(pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
64: pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,
65: pn_debit_amount OUT NOCOPY jai_rgm_stl_balances.debit_balance%TYPE,
66: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE);
67:

Line 64: pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,

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

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

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

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

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

Line 75: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,

71: pv_process_flag OUT NOCOPY VARCHAR2,
72: pv_process_message OUT NOCOPY VARCHAR2);
73:
74: FUNCTION get_last_settlement_date(pn_regime_id IN jai_rgm_settlements.regime_id%type,
75: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
76: pn_location_id IN jai_rgm_stl_balances.location_id%TYPE)
77: RETURN DATE; ---4245365
78: /*Below code add by JMEENA for bug#7445742 */
79: /*

Line 76: pn_location_id IN jai_rgm_stl_balances.location_id%TYPE)

72: pv_process_message OUT NOCOPY VARCHAR2);
73:
74: FUNCTION get_last_settlement_date(pn_regime_id IN jai_rgm_settlements.regime_id%type,
75: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
76: pn_location_id IN jai_rgm_stl_balances.location_id%TYPE)
77: RETURN DATE; ---4245365
78: /*Below code add by JMEENA for bug#7445742 */
79: /*
80: ||The following function addded by rchandan for bug#6835541

Line 91: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,

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

Line 92: pn_location_id IN jai_rgm_stl_balances.location_id%TYPE,

88: RETURN DATE;
89:
90: PROCEDURE get_last_balance_amount(pn_regime_id IN jai_rgm_settlements.regime_id%type,
91: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
92: pn_location_id IN jai_rgm_stl_balances.location_id%TYPE,
93: pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,
94: pn_debit_amount OUT NOCOPY jai_rgm_stl_balances.debit_balance%TYPE,
95: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE,
96: pv_service_type_code IN jai_rgm_stl_balances.service_type_code%TYPE DEFAULT NULL /* added by ssawant for bug 5879769 */

Line 93: pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,

89:
90: PROCEDURE get_last_balance_amount(pn_regime_id IN jai_rgm_settlements.regime_id%type,
91: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
92: pn_location_id IN jai_rgm_stl_balances.location_id%TYPE,
93: pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,
94: pn_debit_amount OUT NOCOPY jai_rgm_stl_balances.debit_balance%TYPE,
95: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE,
96: pv_service_type_code IN jai_rgm_stl_balances.service_type_code%TYPE DEFAULT NULL /* added by ssawant for bug 5879769 */
97: ); ---4245365

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

90: PROCEDURE get_last_balance_amount(pn_regime_id IN jai_rgm_settlements.regime_id%type,
91: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
92: pn_location_id IN jai_rgm_stl_balances.location_id%TYPE,
93: pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,
94: pn_debit_amount OUT NOCOPY jai_rgm_stl_balances.debit_balance%TYPE,
95: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE,
96: pv_service_type_code IN jai_rgm_stl_balances.service_type_code%TYPE DEFAULT NULL /* added by ssawant for bug 5879769 */
97: ); ---4245365
98:

Line 95: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE,

91: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
92: pn_location_id IN jai_rgm_stl_balances.location_id%TYPE,
93: pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,
94: pn_debit_amount OUT NOCOPY jai_rgm_stl_balances.debit_balance%TYPE,
95: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE,
96: pv_service_type_code IN jai_rgm_stl_balances.service_type_code%TYPE DEFAULT NULL /* added by ssawant for bug 5879769 */
97: ); ---4245365
98:
99: END jai_cmn_rgm_settlement_pkg;

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

92: pn_location_id IN jai_rgm_stl_balances.location_id%TYPE,
93: pv_tax_type IN jai_rgm_stl_balances.tax_type%TYPE,
94: pn_debit_amount OUT NOCOPY jai_rgm_stl_balances.debit_balance%TYPE,
95: pn_credit_amount OUT NOCOPY jai_rgm_stl_balances.credit_balance%TYPE,
96: pv_service_type_code IN jai_rgm_stl_balances.service_type_code%TYPE DEFAULT NULL /* added by ssawant for bug 5879769 */
97: ); ---4245365
98:
99: END jai_cmn_rgm_settlement_pkg;