APPS.CST_ITEM_COST_IMPORT_INTERFACE dependencies on CST_ITEM_CST_DTLS_INTERFACE_S

Line 95: SET transaction_id = CST_ITEM_CST_DTLS_INTERFACE_S.NEXTVAL,

91: l_stmt_no := 40;
92:
93: /* Set the unique transaction_id for each row */
94: Update CST_ITEM_CST_DTLS_INTERFACE
95: SET transaction_id = CST_ITEM_CST_DTLS_INTERFACE_S.NEXTVAL,
96: request_id = FND_GLOBAL.CONC_REQUEST_ID,
97: error_code = null,
98: error_explanation = null,
99: program_application_id = FND_GLOBAL.PROG_APPL_ID,

Line 357: Update CST_ITEM_CST_DTLS_INTERFACE set

353:
354:
355: /* set The process_flag to 2 */
356:
357: Update CST_ITEM_CST_DTLS_INTERFACE set
358: process_flag = 3 where
359: group_id=SEQ_NEXTVAL
360: AND error_flag is null
361: AND process_flag = 2;

Line 510: UPDATE CST_ITEM_CST_DTLS_INTERFACE set

506:
507: l_stmt_no := 18;
508: fnd_file.put_line(fnd_file.log,'done checking for inv asset flag to be 1 or 2');
509:
510: UPDATE CST_ITEM_CST_DTLS_INTERFACE set
511: error_flag = 'E',
512: error_code = 'CST_INVALID_RESRATE',
513: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_RESRATE'),1,240)
514: where error_flag is null

Line 579: Update CST_ITEM_CST_DTLS_INTERFACE set

575: fnd_file.put_line(fnd_file.log,'done erroring out rows for the same item,org,cost type combo if even one of them has errored out');
576:
577: l_stmt_no := 40;
578:
579: Update CST_ITEM_CST_DTLS_INTERFACE set
580: process_flag = 4 where
581: group_id=SEQ_NEXTVAL
582: AND error_flag is null
583: AND process_flag = 3;

Line 720: Update CST_ITEM_CST_DTLS_INTERFACE set

716:
717: /* The following statement sets the basis factor and net_yield_or_shrinkage_factor.
718: The basis factor will be set to values like the form does today in the applications */
719:
720: Update CST_ITEM_CST_DTLS_INTERFACE set
721: basis_factor = Decode(basis_type,1,1,2,(1/lot_size),6,(Activity_units/item_units))
722: where error_flag is null
723: and group_id = SEQ_NEXTVAL
724: and basis_type IN (1,2,6);

Line 765: Update CST_ITEM_CST_DTLS_INTERFACE set

761: l_stmt_no :=20;
762:
763: /* now calculate the item cost for each row for basis */
764:
765: Update CST_ITEM_CST_DTLS_INTERFACE set
766: item_cost = NVL(usage_rate_or_amount,0) * NVL(basis_factor,1) * NVL(net_yield_or_shrinkage_factor,1) * NVL(resource_rate,1)
767: where basis_type IN (1,2,3,6)
768: AND error_flag is null
769: and group_id = SEQ_NEXTVAL;