256: AND CUSTOMER_TRX_ID = CUST_TRX_ID;
257: END;
258: IF NVL(FLAG_PRINT
259: ,'Y') = 'Y' THEN
260: ARP_CT_PKG.LOCK_FETCH_P(L_TRX_REC
261: ,CUST_TRX_ID);
262: L_TRX_REC.PRINTING_ORIGINAL_DATE := SYSDATE;
263: L_TRX_REC.PRINTING_LAST_PRINTED := SYSDATE;
264: L_TRX_REC.PRINTING_COUNT := 1;
262: L_TRX_REC.PRINTING_ORIGINAL_DATE := SYSDATE;
263: L_TRX_REC.PRINTING_LAST_PRINTED := SYSDATE;
264: L_TRX_REC.PRINTING_COUNT := 1;
265: L_TRX_REC.PRINTING_PENDING := 'N';
266: ARP_CT_PKG.UPDATE_P_PRINT(L_TRX_REC
267: ,CUST_TRX_ID);
268: ELSE
269: ARP_CT_PKG.LOCK_FETCH_P(L_TRX_REC
270: ,CUST_TRX_ID);
265: L_TRX_REC.PRINTING_PENDING := 'N';
266: ARP_CT_PKG.UPDATE_P_PRINT(L_TRX_REC
267: ,CUST_TRX_ID);
268: ELSE
269: ARP_CT_PKG.LOCK_FETCH_P(L_TRX_REC
270: ,CUST_TRX_ID);
271: L_TRX_REC.PRINTING_LAST_PRINTED := SYSDATE;
272: L_TRX_REC.PRINTING_COUNT := P_COUNT + 1;
273: ARP_CT_PKG.UPDATE_P_PRINT(L_TRX_REC
269: ARP_CT_PKG.LOCK_FETCH_P(L_TRX_REC
270: ,CUST_TRX_ID);
271: L_TRX_REC.PRINTING_LAST_PRINTED := SYSDATE;
272: L_TRX_REC.PRINTING_COUNT := P_COUNT + 1;
273: ARP_CT_PKG.UPDATE_P_PRINT(L_TRX_REC
274: ,CUST_TRX_ID);
275: END IF;
276: EXCEPTION
277: WHEN OTHERS THEN