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.GMS_AWARD_DIST_ENG dependencies on GMS_DISTRIBUTION_DETAILS

Line 114: DELETE from gms_distribution_details A

110: p_dist_award_id NUMBER ) return NUMBER IS
111: l_count_rec NUMBER ;
112: BEGIN
113: IF p_document_type = 'ENC' THEN
114: DELETE from gms_distribution_details A
115: WHERE document_type = p_document_type
116: and exists ( select 'X' from gms_distributions B
117: where A.document_header_id = b.document_distribution_id
118: and B.document_header_id = p_header_id

Line 121: DELETE from gms_distribution_details

117: where A.document_header_id = b.document_distribution_id
118: and B.document_header_id = p_header_id
119: and b.document_type = p_document_type ) ;
120: ELSE
121: DELETE from gms_distribution_details
122: WHERE document_header_id = p_header_id
123: AND document_type = p_document_type ;
124: END IF ;
125:

Line 823: insert into gms_distribution_details (

819: x_doc_header_id := valid_fp_tab(tab_index).document_header_id ;
820: x_doc_dist_id := valid_fp_tab(tab_index).document_distribution_id ;
821: END IF ;
822:
823: insert into gms_distribution_details (
824: document_header_id,
825: document_distribution_id,
826: document_type,
827: funding_pattern_id,

Line 1138: delete from gms_distribution_details

1134: p_recs_rejected := l_rejected ;
1135: delete from gms_distributions
1136: where creation_date <= ( TRUNC(sysdate) -1 ) ;
1137:
1138: delete from gms_distribution_details
1139: where creation_date <= ( TRUNC(sysdate) -1 ) ;
1140: COMMIT ;
1141: EXCEPTION
1142: when others then

Line 1168: UPDATE GMS_DISTRIBUTION_DETAILS

1164: count_new_rec NUMBER ;
1165: BEGIN
1166: pa_cc_utils.set_curr_function('PROC_INSERT_TRANS');
1167:
1168: UPDATE GMS_DISTRIBUTION_DETAILS
1169: SET remarks = to_char(PA_TXN_INTERFACE_S.nextval)
1170: WHERE document_header_id = p_xface_id
1171: AND document_type = 'EXP'
1172: AND distribution_number > 1 ;

Line 1231: GMS_DISTRIBUTION_DETAILS GTN,

1227: --TXN.EXPENDITURE_ENDING_DATE ,
1228: --TXN.EXPENDITURE_ITEM_DATE ,
1229: --TXN.PROJECT_NUMBER
1230: FROM PA_TRANSACTION_INTERFACE_ALL TXN,
1231: GMS_DISTRIBUTION_DETAILS GTN,
1232: GMS_AWARDS_ALL GA -- Bug 3221039
1233: WHERE GTN.document_header_id = p_xface_id
1234: AND GA.award_id = GTN.award_id -- Bug 3221039
1235: AND TXN.transaction_source = P_transaction_source

Line 1457: GMS_DISTRIBUTION_DETAILS GTN

1453: TXN.PO_LINE_ID ,
1454: TXN.PERSON_TYPE ,
1455: TXN.PO_PRICE_TYPE
1456: FROM PA_TRANSACTION_INTERFACE_ALL TXN,
1457: GMS_DISTRIBUTION_DETAILS GTN
1458: WHERE GTN.document_header_id = p_xface_id
1459: AND GTN.document_type = 'EXP'
1460: AND TXN.transaction_source = P_transaction_source
1461: AND GTN.distribution_number > 1

Line 1466: DELETE from GMS_DISTRIBUTION_DETAILS

1462: AND GTN.document_distribution_id = TXN.TXN_INTERFACE_ID ;
1463:
1464: count_new_rec := SQL%ROWCOUNT ;
1465: pa_cc_utils.log_message(' PA Transactions inserted :'||to_char(SQL%ROWCOUNT));
1466: DELETE from GMS_DISTRIBUTION_DETAILS
1467: where document_header_id = p_xface_id ;
1468:
1469: pa_cc_utils.log_message(' No of GMS_DISTRIBUTION_DETAILS records deleted :'||to_char(SQL%ROWCOUNT));
1470: DELETE from GMS_DISTRIBUTIONS

Line 1469: pa_cc_utils.log_message(' No of GMS_DISTRIBUTION_DETAILS records deleted :'||to_char(SQL%ROWCOUNT));

1465: pa_cc_utils.log_message(' PA Transactions inserted :'||to_char(SQL%ROWCOUNT));
1466: DELETE from GMS_DISTRIBUTION_DETAILS
1467: where document_header_id = p_xface_id ;
1468:
1469: pa_cc_utils.log_message(' No of GMS_DISTRIBUTION_DETAILS records deleted :'||to_char(SQL%ROWCOUNT));
1470: DELETE from GMS_DISTRIBUTIONS
1471: where document_header_id = p_xface_id ;
1472: pa_cc_utils.log_message(' No of GMS_DISTRIBUTIONS records deleted :'||to_char(SQL%ROWCOUNT));
1473: pa_cc_utils.reset_curr_function;

Line 2356: from gms_distribution_details B,

2352: -- Award number and to populate both award id and award number .
2353:
2354: update gms_transaction_interface_all A
2355: set (a.award_id,a.award_number) = ( select B.award_id,GA.award_number -- Bug 3221039
2356: from gms_distribution_details B,
2357: gms_awards_all GA
2358: where a.txn_interface_id = b.document_distribution_id
2359: and B.document_header_id = P_xface_id
2360: and B.distribution_number= 1

Line 2369: from gms_distribution_details C

2365: ( (award_number IS NULL AND nvl(award_id,0)= x_default_dist_award_id )
2366: OR
2367: (award_number = l_default_dist_award_number)) -- Bug 3221039
2368: and A.txn_interface_id in ( select C.document_distribution_id
2369: from gms_distribution_details C
2370: where C.document_header_id = P_xface_id
2371: and C.distribution_number= 1
2372: and C.document_type = 'EXP' );
2373:

Line 2390: from gms_distribution_details B

2386: B.denom_burdened_cost,
2387: B.acct_raw_cost,
2388: B.acct_burdened_cost,
2389: B.receipt_currency_amount
2390: from gms_distribution_details B
2391: where a.txn_interface_id = b.document_distribution_id
2392: and B.document_header_id = P_xface_id
2393: and B.distribution_number= 1
2394: and B.document_type = 'EXP' )

Line 2398: from gms_distribution_details C

2394: and B.document_type = 'EXP' )
2395: where A.transaction_source = P_transaction_source
2396: --and A.batch_name = p_batch
2397: and A.txn_interface_id IN ( SELECT C.document_distribution_id
2398: from gms_distribution_details C
2399: WHERE C.document_header_id = P_xface_id
2400: and C.distribution_number= 1
2401: and C.document_type = 'EXP' );
2402: