APPS.PA_TRX_IMPORT dependencies on PA_TRANSACTION_XFACE_CONTROL

Line 5743: pa_transaction_xface_control xc

5739: , xc.batch_name ||xc.system_linkage_function|| to_char(X_xface_id) exp_group_name
5740: , xc.transaction_count
5741: , xc.processed_count
5742: FROM
5743: pa_transaction_xface_control xc
5744: WHERE
5745: xc.transaction_source = X_transaction_source
5746: AND xc.batch_name = nvl(X_batch, xc.batch_name)
5747: AND xc.status = 'PENDING'

Line 6289: pa_transaction_xface_control

6285: 1
6286: INTO
6287: dummy
6288: FROM
6289: pa_transaction_xface_control
6290: WHERE
6291: transaction_source = trx_source
6292: AND batch_name = batch
6293: AND system_linkage_function = etypeclasscode

Line 6313: UPDATE pa_transaction_xface_control

6309: IF PG_DEBUG = 'Y' THEN
6310: log_message('log_message: ' || 'Got lock for record');
6311: END IF;
6312:
6313: UPDATE pa_transaction_xface_control
6314: SET
6315: interface_id = X_xface_id
6316: , status = 'IN_PROGRESS'
6317: WHERE

Line 6324: log_message('log_message: ' || 'Updated interface id/status on pa_transaction_xface_control');

6320: AND system_linkage_function = etypeclasscode
6321: AND status = 'PENDING';
6322:
6323: IF PG_DEBUG = 'Y' THEN
6324: log_message('log_message: ' || 'Updated interface id/status on pa_transaction_xface_control');
6325: END IF;
6326:
6327: pa_cc_utils.reset_curr_function;
6328: RETURN 0;

Line 6371: UPDATE pa_transaction_xface_control

6367: IF PG_DEBUG = 'Y' THEN
6368: log_message('log_message: ' || 'Set ctrl record status to PENDING');
6369: END IF;
6370:
6371: UPDATE pa_transaction_xface_control
6372: SET status = 'PENDING',
6373: intermediate_flag = 'Y',
6374: processed_count = processed_count + P_BatchProcCount
6375: WHERE transaction_source = P_TrxSource

Line 6391: UPDATE pa_transaction_xface_control

6387: IF PG_DEBUG = 'Y' THEN
6388: log_message('log_message: ' || 'Set ctrl record status to PROCESSED');
6389: END IF;
6390:
6391: UPDATE pa_transaction_xface_control
6392: SET status = 'PROCESSED',
6393: processed_count = processed_count + P_BatchProcCount
6394: WHERE transaction_source = P_TrxSource
6395: AND batch_name = P_BatchName

Line 7193: FROM pa_transaction_xface_control xc

7189: If l_Batch_Size = 0 Then
7190:
7191: SELECT sum(xc.transaction_count)
7192: INTO l_Batch_Size
7193: FROM pa_transaction_xface_control xc
7194: WHERE xc.transaction_source = TrxBatch.transaction_source
7195: AND xc.status = 'PENDING';
7196:
7197: IF PG_DEBUG = 'Y' THEN