APPS.GMS_LD_PKG dependencies on GMS_TRANSACTION_INTERFACE_ALL

Line 204: FROM gms_transaction_interface_all

200:
201: CURSOR c_get_org_enc_item_id(p_txn_interface_id NUMBER) IS
202: SELECT original_encumbrance_item_id ,
203: DECODE(original_encumbrance_item_id,NULL,NULL,'Y') net_zero_adjustment_flag
204: FROM gms_transaction_interface_all
205: WHERE txn_interface_id = p_txn_interface_id ;
206:
207: TrxRec TrxRecs%ROWTYPE;
208: X_status varchar2(100);

Line 368: FROM gms_transaction_interface_all gtxn,

364: -- Bug 31221039 : Modified the below cursor to fetch award_id based on award_number/award_id.
365:
366: CURSOR C1 IS
367: SELECT ga.award_id
368: FROM gms_transaction_interface_all gtxn,
369: gms_awards_all ga
370: WHERE ((gtxn.award_number IS NULL AND ga.award_id = NVL(gtxn.award_id,0) ) OR
371: (ga.award_number = gtxn.award_number) )
372: AND gtxn.txn_interface_id = Trxrec.txn_interface_id ;

Line 993: /*UPDATE gms_transaction_interface_all

989:
990: -- Bug 3221039 : Commented the following update statement as gms_transaction_
991: -- interface_all.transaction_status_code column is obsolete
992:
993: /*UPDATE gms_transaction_interface_all
994: SET transaction_status_code = 'R'
995: WHERE orig_transaction_reference = TrxRec.orig_transaction_reference;*/
996:
997: X_success := 'S' ;

Line 1144: /* UPDATE gms_transaction_interface_all

1140:
1141: -- Bug 3221039 : Commented the following update statement as gms_transaction_
1142: -- interface_all.transaction_status_code column is obsolete
1143:
1144: /* UPDATE gms_transaction_interface_all
1145: SET transaction_status_code = 'R'
1146: WHERE orig_transaction_reference = TrxRec.orig_transaction_reference; */
1147:
1148: pa_cc_utils.log_message('This record is rejected Stage: Pre-Process ' || X_status, 1);

Line 1178: /* UPDATE gms_transaction_interface_all

1174:
1175: -- Bug 3221039 : Commented the following update statement as gms_transaction_
1176: -- interface_all.transaction_status_code column is obsolete
1177:
1178: /* UPDATE gms_transaction_interface_all
1179: SET transaction_status_code = 'R'
1180: WHERE orig_transaction_reference = TrxRec.orig_transaction_reference; */
1181:
1182: X_success := 'S' ;

Line 1211: /*UPDATE gms_transaction_interface_all

1207:
1208: -- Bug 3221039 : Commented the following update statement as gms_transaction_
1209: -- interface_all.transaction_status_code column is obsolete
1210:
1211: /*UPDATE gms_transaction_interface_all
1212: SET transaction_status_code = 'R'
1213: WHERE batch_name = P_batch ; */
1214:
1215:

Line 1307: /*UPDATE gms_transaction_interface_all

1303:
1304: -- Bug 3221039 : Commented the following update statement as gms_transaction_
1305: -- interface_all.transaction_status_code column is obsolete
1306:
1307: /*UPDATE gms_transaction_interface_all
1308: SET transaction_status_code = 'R'
1309: WHERE orig_transaction_reference = TrxRec.orig_transaction_reference
1310: AND transaction_source = P_TRANSACTION_SOURCE;*/
1311:

Line 1409: /*UPDATE gms_transaction_interface_all

1405:
1406: -- Bug 3221039 : Commented the following update statement as gms_transaction_
1407: -- interface_all.transaction_status_code column is obsolete
1408:
1409: /*UPDATE gms_transaction_interface_all
1410: SET transaction_status_code = 'A'
1411: WHERE orig_transaction_reference = TrxRec.orig_transaction_reference
1412: AND transaction_source = P_TRANSACTION_SOURCE;*/
1413:

Line 1432: /* UPDATE gms_transaction_interface_all

1428:
1429: -- Bug 3221039 : Commented the following update statement as gms_transaction_
1430: -- interface_all.transaction_status_code column is obsolete
1431:
1432: /* UPDATE gms_transaction_interface_all
1433: SET transaction_status_code = 'R'
1434: WHERE orig_transaction_reference = TrxRec.orig_transaction_reference
1435: AND transaction_source = P_TRANSACTION_SOURCE; */
1436:

Line 1468: /* UPDATE gms_transaction_interface_all

1464:
1465: -- Bug 3221039 : Commented the following update statement as gms_transaction_
1466: -- interface_all.transaction_status_code column is obsolete
1467:
1468: /* UPDATE gms_transaction_interface_all
1469: SET transaction_status_code = 'R'
1470: WHERE orig_transaction_reference = TrxRec.orig_transaction_reference; */
1471:
1472: pa_cc_utils.log_message('Unexpected error :TrxRecs LOOP: '||SQLERRM,1);

Line 1487: DELETE gms_transaction_interface_all

1483: -- based on purgeable flag.
1484:
1485: IF NVL(l_purgeable_flag,'N') = 'Y' THEN
1486:
1487: DELETE gms_transaction_interface_all
1488: WHERE txn_interface_id IN (SELECT txn_interface_id
1489: FROM pa_transaction_interface_all
1490: WHERE interface_id = P_XFACE_ID
1491: AND transaction_status_code ='A' );