APPS.PA_TRX_IMPORT dependencies on PA_TRANSACTION_XFACE_CONTROL

Line 6207: pa_transaction_xface_control xc

6203: , xc.batch_name ||xc.system_linkage_function|| to_char(X_xface_id) exp_group_name
6204: , xc.transaction_count
6205: , xc.processed_count
6206: FROM
6207: pa_transaction_xface_control xc
6208: WHERE
6209: xc.transaction_source = X_transaction_source
6210: AND xc.batch_name = nvl(X_batch, xc.batch_name)
6211: AND xc.status = 'PENDING'

Line 6852: pa_transaction_xface_control

6848: 1
6849: INTO
6850: dummy
6851: FROM
6852: pa_transaction_xface_control
6853: WHERE
6854: transaction_source = trx_source
6855: AND batch_name = batch
6856: AND system_linkage_function = etypeclasscode

Line 6876: UPDATE pa_transaction_xface_control

6872: IF PG_DEBUG = 'Y' THEN
6873: log_message('log_message: ' || 'Got lock for record');
6874: END IF;
6875:
6876: UPDATE pa_transaction_xface_control
6877: SET
6878: interface_id = X_xface_id
6879: , status = 'IN_PROGRESS'
6880: WHERE

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

6883: AND system_linkage_function = etypeclasscode
6884: AND status = 'PENDING';
6885:
6886: IF PG_DEBUG = 'Y' THEN
6887: log_message('log_message: ' || 'Updated interface id/status on pa_transaction_xface_control');
6888: END IF;
6889:
6890: pa_cc_utils.reset_curr_function;
6891: RETURN 0;

Line 6934: UPDATE pa_transaction_xface_control

6930: IF PG_DEBUG = 'Y' THEN
6931: log_message('log_message: ' || 'Set ctrl record status to PENDING');
6932: END IF;
6933:
6934: UPDATE pa_transaction_xface_control
6935: SET status = 'PENDING',
6936: intermediate_flag = 'Y',
6937: processed_count = processed_count + P_BatchProcCount
6938: WHERE transaction_source = P_TrxSource

Line 6954: UPDATE pa_transaction_xface_control

6950: IF PG_DEBUG = 'Y' THEN
6951: log_message('log_message: ' || 'Set ctrl record status to PROCESSED');
6952: END IF;
6953:
6954: UPDATE pa_transaction_xface_control
6955: SET status = 'PROCESSED',
6956: processed_count = processed_count + P_BatchProcCount
6957: WHERE transaction_source = P_TrxSource
6958: AND batch_name = P_BatchName

Line 7814: FROM pa_transaction_xface_control xc

7810: If l_Batch_Size = 0 Then
7811:
7812: SELECT sum(xc.transaction_count)
7813: INTO l_Batch_Size
7814: FROM pa_transaction_xface_control xc
7815: WHERE xc.transaction_source = TrxBatch.transaction_source
7816: AND xc.status = 'PENDING';
7817:
7818: IF PG_DEBUG = 'Y' THEN