APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on JAI_RGM_TRX_REFS

Line 9: the jai_rgm_trx_refs and jai_rgms_trx_records appropriately.

5: Created By : aiyer
6: Created Date : 27-jan-2005
7: Enhancement Bug : 4146634
8: Purpose : Process the Service Tax AR records (Invoices,Credit memo's and Cash Receipts Applications) and populate
9: the jai_rgm_trx_refs and jai_rgms_trx_records appropriately.
10: Called From : jai_rgm_trx_processing.process_batch
11:
12: Dependency Due To The Current Bug :
13: This object has been newly created with AUTHID CURRENT_USER as a part of the service tax enhancement.

Line 78: p_total_disc_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ,

74: );
75:
76: procedure get_ar_tax_disc_accnt ( p_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE ,
77: p_org_id AR_RECEIVABLES_TRX_ALL.ORG_ID%TYPE ,
78: p_total_disc_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ,
79: p_tax_ediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_EDISCOUNTED%TYPE ,
80: p_earned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
81: p_tax_uediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_UEDISCOUNTED%TYPE ,
82: p_unearned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,

Line 92: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,

88: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
89: p_from_date IN DATE ,
90: p_to_date IN DATE ,
91: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
92: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
93: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
94: p_process_flag OUT NOCOPY VARCHAR2 ,
95: p_process_message OUT NOCOPY VARCHAR2,
96: p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL

Line 105: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,

101: p_from_date IN DATE ,
102: p_to_date IN DATE ,
103: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
104: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
105: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
106: p_process_flag OUT NOCOPY VARCHAR2 ,
107: p_process_message OUT NOCOPY VARCHAR2
108: ,p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL );
109:

Line 116: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,

112: p_from_date IN DATE ,
113: p_to_date IN DATE ,
114: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
115: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
116: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
117: p_process_flag OUT NOCOPY VARCHAR2 ,
118: p_process_message OUT NOCOPY VARCHAR2
119: ,p_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL );
120:

Line 127: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,

123: p_from_date IN DATE ,
124: p_to_date IN DATE ,
125: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
126: p_source IN varchar2, --File.Sql.35 Cbabu JAI_CONSTANTS.SOURCE_AR%TYPE ,
127: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
128: p_process_flag OUT NOCOPY VARCHAR2 ,
129: p_process_message OUT NOCOPY VARCHAR2
130: ,p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL);
131: /*Bug 11821537 - Start*/

Line 138: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,

134: p_from_date IN DATE ,
135: p_to_date IN DATE ,
136: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
137: p_source IN varchar2 ,
138: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
139: p_process_flag OUT NOCOPY VARCHAR2 ,
140: p_process_message OUT NOCOPY VARCHAR2 ,
141: p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL) ;
142: /*Bug 11821537 - End*/

Line 148: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,

144: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
145: p_from_date IN DATE ,
146: p_to_date IN DATE ,
147: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
148: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
149: p_process_flag OUT NOCOPY VARCHAR2 ,
150: p_process_message OUT NOCOPY VARCHAR2 ,
151: p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL /*5879769*/
152: );