DBA Data[Home] [Help]

APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on JAI_RGM_PARTIES

Line 749: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,

745:
746:
747:
748: procedure populate_inv_cm_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
749: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
750: p_from_date IN DATE ,
751: p_to_date IN DATE ,
752: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
753: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,

Line 757: p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL

753: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
754: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
755: p_process_flag OUT NOCOPY VARCHAR2 ,
756: p_process_message OUT NOCOPY VARCHAR2,
757: p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL
758: )
759: IS
760: /******************************
761: ||Variable Declaration Section

Line 1184: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,

1180:
1181: END populate_inv_cm_references;
1182:
1183: procedure delete_non_existant_cm ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
1184: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
1185: p_from_date IN DATE ,
1186: p_to_date IN DATE ,
1187: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
1188: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,

Line 1192: ,p_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL)

1188: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1189: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
1190: p_process_flag OUT NOCOPY VARCHAR2 ,
1191: p_process_message OUT NOCOPY VARCHAR2
1192: ,p_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL)
1193: IS
1194:
1195: ln_eff_cm_tax_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE ;
1196: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;

Line 1683: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,

1679:
1680:
1681:
1682: procedure populate_cm_app ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
1683: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
1684: p_from_date IN DATE ,
1685: p_to_date IN DATE ,
1686: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
1687: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,

Line 1691: , p_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL )

1687: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1688: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
1689: p_process_flag OUT NOCOPY VARCHAR2 ,
1690: p_process_message OUT NOCOPY VARCHAR2
1691: , p_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL )
1692: IS
1693:
1694: ln_eff_cm_tax_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE ;
1695: ln_discounted_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ;

Line 2553: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,

2549: END populate_cm_app;
2550:
2551:
2552: procedure populate_receipt_records ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
2553: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
2554: p_from_date IN DATE ,
2555: p_to_date IN DATE ,
2556: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
2557: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,

Line 2561: ,p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL )

2557: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
2558: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
2559: p_process_flag OUT NOCOPY VARCHAR2 ,
2560: p_process_message OUT NOCOPY VARCHAR2
2561: ,p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL )
2562: IS
2563:
2564: ln_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE ;
2565: ln_eff_cr_tax_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE ;

Line 3384: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,

3380:
3381: /*Bug 11821537 - Start*/
3382:
3383: PROCEDURE populate_repository (p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
3384: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
3385: p_from_date IN DATE ,
3386: p_to_date IN DATE ,
3387: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
3388: p_source IN varchar2 ,

Line 3392: p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL)

3388: p_source IN varchar2 ,
3389: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
3390: p_process_flag OUT NOCOPY VARCHAR2 ,
3391: p_process_message OUT NOCOPY VARCHAR2 ,
3392: p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL)
3393: IS
3394: /*Variables*/
3395: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'CUSTOMER_TRX_LINE_ALL';
3396: lv_called_from CONSTANT varchar2(100) := 'jai_ar_rgm_processing_pkg.populate_repository';

Line 4627: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,

4623: --Add by Xiao for POT Phase III changes, reg bug#12895841 on 1-Aug-2011, end
4624:
4625:
4626: procedure process_records ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
4627: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
4628: p_from_date IN DATE ,
4629: p_to_date IN DATE ,
4630: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
4631: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,

Line 4634: p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL /*5879769*/

4630: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
4631: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
4632: p_process_flag OUT NOCOPY VARCHAR2 ,
4633: p_process_message OUT NOCOPY VARCHAR2 ,
4634: p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL /*5879769*/
4635: )
4636: IS
4637:
4638: lv_source_ar varchar2(2); --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ;

Line 4641: lv_organization_id jai_rgm_parties.organization_id%type;

4637:
4638: lv_source_ar varchar2(2); --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ;
4639: lv_process_flag VARCHAR2(2) ;
4640: lv_process_message VARCHAR2(1996) ;
4641: lv_organization_id jai_rgm_parties.organization_id%type;
4642: /*Bug 11821537 - Start*/
4643: /*--Commented by zhiwei.hou for POT code port
4644: CURSOR c_get_st_accrual_date
4645: IS

Line 5107: cp_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE ,

5103: AND jdt.source_doc_type = JAI_CONSTANTS.ar_cash;
5104:
5105: CURSOR c_get_rgm_attribute ( cp_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ,
5106: cp_attribute_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE ,
5107: cp_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE ,
5108: cp_location_id JAI_RGM_PARTIES.LOCATION_ID%TYPE
5109: )
5110: IS
5111: SELECT

Line 5108: cp_location_id JAI_RGM_PARTIES.LOCATION_ID%TYPE

5104:
5105: CURSOR c_get_rgm_attribute ( cp_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ,
5106: cp_attribute_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE ,
5107: cp_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE ,
5108: cp_location_id JAI_RGM_PARTIES.LOCATION_ID%TYPE
5109: )
5110: IS
5111: SELECT
5112: regime_id ,