APPS.CST_DIAGNOSTICS_PKG dependencies on CST_DIAG_ERRORED_TXNS

Line 130: delete from CST_DIAG_ERRORED_TXNS;

126: L_TXN_COSTED_FLAG VARCHAR2(1);
127: L_TXN_TXFR_TXN_ID NUMBER;
128: L_LOGICAL_TXN_CRTD NUMBER;
129: BEGIN
130: delete from CST_DIAG_ERRORED_TXNS;
131:
132: FOR ORG_REC IN ALL_ACTUAL_COSTING_ORGS LOOP
133: SELECT /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */
134: TRUNC(NVL(MIN(TRANSACTION_DATE),(SYSDATE+1)))

Line 470: INSERT INTO CST_DIAG_ERRORED_TXNS

466: WHERE TRANSACTION_ID = L_MIN_TXN;
467:
468:
469:
470: INSERT INTO CST_DIAG_ERRORED_TXNS
471: ( ORGANIZATION_ID,
472: BOTTLE_NECK_TXN_ID,
473: TRANSACTION_DATE,
474: TRANSACTION_ORGANIZATION_ID,

Line 509: INSERT INTO CST_DIAG_ERRORED_TXNS

505: L_LOGICAL_TXN_CRTD
506: );
507: ELSE
508:
509: INSERT INTO CST_DIAG_ERRORED_TXNS
510: ( ORGANIZATION_ID,
511: BOTTLE_NECK_TXN_ID,
512: TRANSACTION_DATE,
513: TRANSACTION_ORGANIZATION_ID,

Line 811: FROM CST_DIAG_ERRORED_TXNS

807: L_TXN_COMP_TXN_ID ,
808: L_TXN_COSTED_FLAG ,
809: L_WAITING_ORG ,
810: L_LOGICAL_TXN_CRTD
811: FROM CST_DIAG_ERRORED_TXNS
812: WHERE ORGANIZATION_ID =L_ORGANIZATION_ID;
813:
814: --DBMS_OUTPUT.PUT_LINE('TXN DATE :='||L_TXN_DATE);
815:

Line 833: CST_DIAG_ERRORED_TXNS SC

829:
830: SELECT COUNT(MMTT.COMPLETION_TRANSACTION_ID)
831: INTO L_MMTT_COUNT
832: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,
833: CST_DIAG_ERRORED_TXNS SC
834: WHERE SC.ORGANIZATION_ID = L_ORGANIZATION_ID
835: AND SC.TRANSACTION_SOURCE_TYPE_ID = 5
836: AND MMTT.ORGANIZATION_ID = SC.ORGANIZATION_ID
837: AND (MMTT.COMPLETION_TRANSACTION_ID = SC.COMPLETION_TRANSACTION_ID

Line 862: FROM CST_DIAG_ERRORED_TXNS SC

858: ELSIF /* B - CHECK TRANSFER COST */
859: ( L_TXN_ACTION_ID =3 ) THEN
860: SELECT 1
861: INTO L_TRANSFER_COST
862: FROM CST_DIAG_ERRORED_TXNS SC
863: WHERE SC.BOTTLE_NECK_TXN_ID IS NOT NULL
864: AND SC.TRANSACTION_ACTION_ID = 3
865: AND SC.TRANSACTION_COST IS NULL
866: AND EXISTS ( SELECT 'X'

Line 885: FROM CST_DIAG_ERRORED_TXNS SC

881: ( L_TXN_ACTION_ID IN (12,22) ) THEN
882:
883: SELECT 1
884: INTO L_SHIPMENT_COSTED
885: FROM CST_DIAG_ERRORED_TXNS SC
886: WHERE SC.TRANSACTION_ACTION_ID IN (12,21)
887: AND SC.SHIPMENT_COSTED IS NULL
888: AND EXISTS ( SELECT 'X'
889: FROM MTL_CST_TXN_COST_DETAILS MCTCD