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_AR_TCS_REP_PKG dependencies on JAI_RGM_REFS_ALL

Line 45: p_item_classification OUT NOCOPY JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ,

41: );
42:
43: PROCEDURE validate_app_unapp ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ,
44: p_document_type OUT NOCOPY VARCHAR2 ,
45: p_item_classification OUT NOCOPY JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ,
46: p_process_flag OUT NOCOPY VARCHAR2 ,
47: p_process_message OUT NOCOPY VARCHAR2
48: );
49:

Line 69: p_item_classification IN JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ,

65: );
66:
67: PROCEDURE process_applications ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ,
68: p_document_type IN VARCHAR2 ,
69: p_item_classification IN JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ,
70: p_process_flag OUT NOCOPY VARCHAR2 ,
71: p_process_message OUT NOCOPY VARCHAR2
72: );
73:

Line 83: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,

79: p_process_message OUT NOCOPY VARCHAR2
80: );
81:
82: PROCEDURE insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,
83: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,
84: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
85: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
86: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
87: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,

Line 84: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,

80: );
81:
82: PROCEDURE insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,
83: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,
84: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
85: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
86: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
87: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
88: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,

Line 85: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,

81:
82: PROCEDURE insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,
83: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,
84: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
85: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
86: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
87: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
88: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
89: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,

Line 86: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,

82: PROCEDURE insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,
83: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,
84: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
85: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
86: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
87: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
88: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
89: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
90: p_parent_transaction_id IN JAI_RGM_REFS_ALL.parent_transaction_id%TYPE DEFAULT NULL ,

Line 87: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,

83: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,
84: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
85: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
86: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
87: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
88: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
89: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
90: p_parent_transaction_id IN JAI_RGM_REFS_ALL.parent_transaction_id%TYPE DEFAULT NULL ,
91: p_org_tan_no IN JAI_RGM_REFS_ALL.ORG_TAN_NO%TYPE DEFAULT NULL ,

Line 88: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,

84: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
85: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
86: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
87: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
88: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
89: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
90: p_parent_transaction_id IN JAI_RGM_REFS_ALL.parent_transaction_id%TYPE DEFAULT NULL ,
91: p_org_tan_no IN JAI_RGM_REFS_ALL.ORG_TAN_NO%TYPE DEFAULT NULL ,
92: p_document_id IN NUMBER ,

Line 89: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,

85: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
86: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
87: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
88: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
89: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
90: p_parent_transaction_id IN JAI_RGM_REFS_ALL.parent_transaction_id%TYPE DEFAULT NULL ,
91: p_org_tan_no IN JAI_RGM_REFS_ALL.ORG_TAN_NO%TYPE DEFAULT NULL ,
92: p_document_id IN NUMBER ,
93: p_document_type IN VARCHAR2 ,

Line 90: p_parent_transaction_id IN JAI_RGM_REFS_ALL.parent_transaction_id%TYPE DEFAULT NULL ,

86: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
87: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
88: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
89: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
90: p_parent_transaction_id IN JAI_RGM_REFS_ALL.parent_transaction_id%TYPE DEFAULT NULL ,
91: p_org_tan_no IN JAI_RGM_REFS_ALL.ORG_TAN_NO%TYPE DEFAULT NULL ,
92: p_document_id IN NUMBER ,
93: p_document_type IN VARCHAR2 ,
94: p_document_line_id IN NUMBER ,

Line 91: p_org_tan_no IN JAI_RGM_REFS_ALL.ORG_TAN_NO%TYPE DEFAULT NULL ,

87: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
88: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
89: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
90: p_parent_transaction_id IN JAI_RGM_REFS_ALL.parent_transaction_id%TYPE DEFAULT NULL ,
91: p_org_tan_no IN JAI_RGM_REFS_ALL.ORG_TAN_NO%TYPE DEFAULT NULL ,
92: p_document_id IN NUMBER ,
93: p_document_type IN VARCHAR2 ,
94: p_document_line_id IN NUMBER ,
95: p_document_date IN DATE ,

Line 104: p_trx_ref_id OUT NOCOPY JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,

100: p_organization_id IN NUMBER ,
101: p_party_id IN NUMBER ,
102: p_party_site_id IN NUMBER ,
103: p_item_classification IN VARCHAR2 ,
104: p_trx_ref_id OUT NOCOPY JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
105: p_process_flag OUT NOCOPY VARCHAR2 ,
106: p_process_message OUT NOCOPY VARCHAR2
107: );
108:

Line 109: PROCEDURE insert_repository_taxes ( p_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,

105: p_process_flag OUT NOCOPY VARCHAR2 ,
106: p_process_message OUT NOCOPY VARCHAR2
107: );
108:
109: PROCEDURE insert_repository_taxes ( p_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
110: p_tax_id JAI_RGM_TAXES.TAX_ID%TYPE ,
111: p_tax_type JAI_RGM_TAXES.TAX_TYPE%TYPE ,
112: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,
113: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,

Line 121: PROCEDURE copy_taxes_from_source ( p_source_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,

117: p_process_flag OUT NOCOPY VARCHAR2 ,
118: p_process_message OUT NOCOPY VARCHAR2
119: );
120:
121: PROCEDURE copy_taxes_from_source ( p_source_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
122: p_source_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
123: p_source_document_line_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE DEFAULT NULL ,
124: p_apportion_factor IN NUMBER DEFAULT NULL ,
125: p_trx_ref_id IN JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,

Line 122: p_source_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,

118: p_process_message OUT NOCOPY VARCHAR2
119: );
120:
121: PROCEDURE copy_taxes_from_source ( p_source_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
122: p_source_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
123: p_source_document_line_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE DEFAULT NULL ,
124: p_apportion_factor IN NUMBER DEFAULT NULL ,
125: p_trx_ref_id IN JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
126: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 123: p_source_document_line_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE DEFAULT NULL ,

119: );
120:
121: PROCEDURE copy_taxes_from_source ( p_source_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
122: p_source_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
123: p_source_document_line_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE DEFAULT NULL ,
124: p_apportion_factor IN NUMBER DEFAULT NULL ,
125: p_trx_ref_id IN JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
126: p_process_flag OUT NOCOPY VARCHAR2 ,
127: p_process_message OUT NOCOPY VARCHAR2

Line 125: p_trx_ref_id IN JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,

121: PROCEDURE copy_taxes_from_source ( p_source_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
122: p_source_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
123: p_source_document_line_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE DEFAULT NULL ,
124: p_apportion_factor IN NUMBER DEFAULT NULL ,
125: p_trx_ref_id IN JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
126: p_process_flag OUT NOCOPY VARCHAR2 ,
127: p_process_message OUT NOCOPY VARCHAR2
128: );
129:

Line 130: PROCEDURE copy_references ( p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,

126: p_process_flag OUT NOCOPY VARCHAR2 ,
127: p_process_message OUT NOCOPY VARCHAR2
128: );
129:
130: PROCEDURE copy_references ( p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
131: p_new_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
132: p_new_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
133: p_new_document_date IN DATE ,
134: p_apportion_factor IN NUMBER DEFAULT 1 ,

Line 131: p_new_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,

127: p_process_message OUT NOCOPY VARCHAR2
128: );
129:
130: PROCEDURE copy_references ( p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
131: p_new_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
132: p_new_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
133: p_new_document_date IN DATE ,
134: p_apportion_factor IN NUMBER DEFAULT 1 ,
135: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 132: p_new_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,

128: );
129:
130: PROCEDURE copy_references ( p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
131: p_new_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
132: p_new_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
133: p_new_document_date IN DATE ,
134: p_apportion_factor IN NUMBER DEFAULT 1 ,
135: p_process_flag OUT NOCOPY VARCHAR2 ,
136: p_process_message OUT NOCOPY VARCHAR2

Line 146: PROCEDURE generate_document ( p_rgm_ref IN JAI_RGM_REFS_ALL%ROWTYPE ,

142: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
143: p_process_flag OUT NOCOPY VARCHAR2 ,
144: p_process_message OUT NOCOPY VARCHAR2
145: );
146: PROCEDURE generate_document ( p_rgm_ref IN JAI_RGM_REFS_ALL%ROWTYPE ,
147: p_total_tax_amt IN NUMBER ,
148: p_process_flag OUT NOCOPY VARCHAR2 ,
149: p_process_message OUT NOCOPY VARCHAR2
150: );

Line 164: p_party_id IN JAI_RGM_REFS_ALL.PARTY_ID%TYPE ,

160: );
161:
162: PROCEDURE update_pan_for_tcs ( p_return_code OUT NOCOPY VARCHAR2 ,
163: p_errbuf OUT NOCOPY VARCHAR2 ,
164: p_party_id IN JAI_RGM_REFS_ALL.PARTY_ID%TYPE ,
165: p_old_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE ,
166: p_new_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE
167:
168: );