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 132: DELETE from gms_distribution_details A

128: p_dist_award_id NUMBER ) return NUMBER IS
129: l_count_rec NUMBER ;
130: BEGIN
131: IF p_document_type = 'ENC' THEN
132: DELETE from gms_distribution_details A
133: WHERE document_type = p_document_type
134: and exists ( select 'X' from gms_distributions B
135: where A.document_header_id = b.document_distribution_id
136: and B.document_header_id = p_header_id

Line 139: DELETE from gms_distribution_details

135: where A.document_header_id = b.document_distribution_id
136: and B.document_header_id = p_header_id
137: and b.document_type = p_document_type ) ;
138: ELSE
139: DELETE from gms_distribution_details
140: WHERE document_header_id = p_header_id
141: AND document_type = p_document_type ;
142: END IF ;
143:

Line 881: insert into gms_distribution_details (

877: x_doc_header_id := valid_fp_tab(tab_index).document_header_id ;
878: x_doc_dist_id := valid_fp_tab(tab_index).document_distribution_id ;
879: END IF ;
880:
881: insert into gms_distribution_details (
882: document_header_id,
883: document_distribution_id,
884: document_type,
885: funding_pattern_id,

Line 1272: delete from gms_distribution_details

1268: p_recs_rejected := l_rejected ;
1269: delete from gms_distributions
1270: where creation_date <= ( TRUNC(sysdate) -1 ) ;
1271:
1272: delete from gms_distribution_details
1273: where creation_date <= ( TRUNC(sysdate) -1 ) ;
1274: COMMIT ;
1275: EXCEPTION
1276: when others then

Line 1302: UPDATE GMS_DISTRIBUTION_DETAILS

1298: count_new_rec NUMBER ;
1299: BEGIN
1300: pa_cc_utils.set_curr_function('PROC_INSERT_TRANS');
1301:
1302: UPDATE GMS_DISTRIBUTION_DETAILS
1303: SET remarks = to_char(PA_TXN_INTERFACE_S.nextval)
1304: WHERE document_header_id = p_xface_id
1305: AND document_type = 'EXP'
1306: AND distribution_number > 1 ;

Line 1365: GMS_DISTRIBUTION_DETAILS GTN,

1361: --TXN.EXPENDITURE_ENDING_DATE ,
1362: --TXN.EXPENDITURE_ITEM_DATE ,
1363: --TXN.PROJECT_NUMBER
1364: FROM PA_TRANSACTION_INTERFACE_ALL TXN,
1365: GMS_DISTRIBUTION_DETAILS GTN,
1366: GMS_AWARDS_ALL GA -- Bug 3221039
1367: WHERE GTN.document_header_id = p_xface_id
1368: AND GA.award_id = GTN.award_id -- Bug 3221039
1369: AND TXN.transaction_source = P_transaction_source

Line 1591: GMS_DISTRIBUTION_DETAILS GTN

1587: TXN.PO_LINE_ID ,
1588: TXN.PERSON_TYPE ,
1589: TXN.PO_PRICE_TYPE
1590: FROM PA_TRANSACTION_INTERFACE_ALL TXN,
1591: GMS_DISTRIBUTION_DETAILS GTN
1592: WHERE GTN.document_header_id = p_xface_id
1593: AND GTN.document_type = 'EXP'
1594: AND TXN.transaction_source = P_transaction_source
1595: AND GTN.distribution_number > 1

Line 1600: DELETE from GMS_DISTRIBUTION_DETAILS

1596: AND GTN.document_distribution_id = TXN.TXN_INTERFACE_ID ;
1597:
1598: count_new_rec := SQL%ROWCOUNT ;
1599: pa_cc_utils.log_message(' PA Transactions inserted :'||to_char(SQL%ROWCOUNT));
1600: DELETE from GMS_DISTRIBUTION_DETAILS
1601: where document_header_id = p_xface_id ;
1602:
1603: pa_cc_utils.log_message(' No of GMS_DISTRIBUTION_DETAILS records deleted :'||to_char(SQL%ROWCOUNT));
1604: DELETE from GMS_DISTRIBUTIONS

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

1599: pa_cc_utils.log_message(' PA Transactions inserted :'||to_char(SQL%ROWCOUNT));
1600: DELETE from GMS_DISTRIBUTION_DETAILS
1601: where document_header_id = p_xface_id ;
1602:
1603: pa_cc_utils.log_message(' No of GMS_DISTRIBUTION_DETAILS records deleted :'||to_char(SQL%ROWCOUNT));
1604: DELETE from GMS_DISTRIBUTIONS
1605: where document_header_id = p_xface_id ;
1606: pa_cc_utils.log_message(' No of GMS_DISTRIBUTIONS records deleted :'||to_char(SQL%ROWCOUNT));
1607: pa_cc_utils.reset_curr_function;

Line 2490: from gms_distribution_details B,

2486: -- Award number and to populate both award id and award number .
2487:
2488: update gms_transaction_interface_all A
2489: set (a.award_id,a.award_number) = ( select B.award_id,GA.award_number -- Bug 3221039
2490: from gms_distribution_details B,
2491: gms_awards_all GA
2492: where a.txn_interface_id = b.document_distribution_id
2493: and B.document_header_id = P_xface_id
2494: and B.distribution_number= 1

Line 2503: from gms_distribution_details C

2499: ( (award_number IS NULL AND nvl(award_id,0)= x_default_dist_award_id )
2500: OR
2501: (award_number = l_default_dist_award_number)) -- Bug 3221039
2502: and A.txn_interface_id in ( select C.document_distribution_id
2503: from gms_distribution_details C
2504: where C.document_header_id = P_xface_id
2505: and C.distribution_number= 1
2506: and C.document_type = 'EXP' );
2507:

Line 2524: from gms_distribution_details B

2520: B.denom_burdened_cost,
2521: B.acct_raw_cost,
2522: B.acct_burdened_cost,
2523: B.receipt_currency_amount
2524: from gms_distribution_details B
2525: where a.txn_interface_id = b.document_distribution_id
2526: and B.document_header_id = P_xface_id
2527: and B.distribution_number= 1
2528: and B.document_type = 'EXP' )

Line 2532: from gms_distribution_details C

2528: and B.document_type = 'EXP' )
2529: where A.transaction_source = P_transaction_source
2530: --and A.batch_name = p_batch
2531: and A.txn_interface_id IN ( SELECT C.document_distribution_id
2532: from gms_distribution_details C
2533: WHERE C.document_header_id = P_xface_id
2534: and C.distribution_number= 1
2535: and C.document_type = 'EXP' );
2536: