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 1147: /* UPDATE gms_transaction_interface_all

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

Line 1181: /* UPDATE gms_transaction_interface_all

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

Line 1214: /*UPDATE gms_transaction_interface_all

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

Line 1310: /*UPDATE gms_transaction_interface_all

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

Line 1412: /*UPDATE gms_transaction_interface_all

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

Line 1435: /* UPDATE gms_transaction_interface_all

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

Line 1471: /* UPDATE gms_transaction_interface_all

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

Line 1490: DELETE gms_transaction_interface_all

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