APPS.CSTPSCCR dependencies on CSTPSCCR

Line 1: PACKAGE BODY CSTPSCCR AS

1: PACKAGE BODY CSTPSCCR AS
2: /* $Header: CSTSCCRB.pls 120.15.12010000.3 2008/10/21 12:37:06 smsasidh ship $ */
3:
4:
5: FUNCTION remove_rolledup_costs(

Line 58: return_code := cstpsccr.cstrwait_lock(

54:
55: l_stmt_num := 15;
56: -- SCAPI: always do explicit lock
57: -- Bug 3111820: moved cstrwait_lock from cstsccru
58: return_code := cstpsccr.cstrwait_lock(
59: p_dest_cost_type_id,
60: default_cost_type_id,
61: p_rollup_id,
62: x_err_buf,

Line 419: x_err_buf := 'CSTPSCCR.remove_rolledup_costs: ' ||'Success';

415: AND CIC2.cost_type_id = CICD.cost_type_id
416: AND CIC2.based_on_rollup_flag = 1);
417: end if;
418:
419: x_err_buf := 'CSTPSCCR.remove_rolledup_costs: ' ||'Success';
420: return(status);
421:
422: EXCEPTION
423: when LOCKING_ERROR then

Line 427: x_err_buf := 'CSTPSCCR.remove_rolledup_costs ' ||'stmt_num= '||l_stmt_num||':'|| substrb(sqlerrm,1,60);

423: when LOCKING_ERROR then
424: return(return_code);
425: when others then
426: status := SQLCODE;
427: x_err_buf := 'CSTPSCCR.remove_rolledup_costs ' ||'stmt_num= '||l_stmt_num||':'|| substrb(sqlerrm,1,60);
428: return(status);
429:
430: END remove_rolledup_costs;
431:

Line 539: status := CSTPSCCR.cstrlock('CST_ITEM_COSTS',l_dest_cost_type_id,

535: ** Lock the table of CST_ITEM_COSTS
536: */
537: -- SCAPI: use loop only if locking_flag is not yes
538: if (l_locking_flag = 1) then
539: status := CSTPSCCR.cstrlock('CST_ITEM_COSTS',l_dest_cost_type_id,
540: l_default_cost_type_id,
541: l_rollup_id,err_buf,l_locking_flag);
542: else
543: WHILE (counter < NUM_TRIES and status = -54)

Line 545: status := CSTPSCCR.cstrlock('CST_ITEM_COSTS',l_dest_cost_type_id,

541: l_rollup_id,err_buf,l_locking_flag);
542: else
543: WHILE (counter < NUM_TRIES and status = -54)
544: LOOP
545: status := CSTPSCCR.cstrlock('CST_ITEM_COSTS',l_dest_cost_type_id,
546: l_default_cost_type_id,
547: l_rollup_id,err_buf,l_locking_flag);
548: if status = -54 then
549: DBMS_LOCK.SLEEP(SLEEP_TIME);

Line 569: status := CSTPSCCR.cstrlock('CST_ITEM_COST_DETAILS',l_dest_cost_type_id,

565: */
566: -- SCAPI: use loop only if locking_flag is not yes
567: status := -54;
568: if (l_locking_flag = 1) then
569: status := CSTPSCCR.cstrlock('CST_ITEM_COST_DETAILS',l_dest_cost_type_id,
570: l_default_cost_type_id,
571: l_rollup_id,err_buf,l_locking_flag);
572: else
573: while (counter < NUM_TRIES and status = -54)

Line 575: status := CSTPSCCR.cstrlock('CST_ITEM_COST_DETAILS',

571: l_rollup_id,err_buf,l_locking_flag);
572: else
573: while (counter < NUM_TRIES and status = -54)
574: LOOP
575: status := CSTPSCCR.cstrlock('CST_ITEM_COST_DETAILS',
576: l_dest_cost_type_id, l_default_cost_type_id,
577: l_rollup_id,err_buf,l_locking_flag);
578: if status = -54 then
579: DBMS_LOCK.SLEEP(SLEEP_TIME);

Line 2407: err_buf := 'CSTPSCCR.cstsccru ' || 'Success';

2403: END LOOP;
2404: CLOSE cllc_cur;
2405:
2406: return_code := 0;
2407: err_buf := 'CSTPSCCR.cstsccru ' || 'Success';
2408: return(return_code);
2409:
2410: EXCEPTION
2411: when STANDARD_ERROR then

Line 3608: END CSTPSCCR;

3604: err_buf := 'SUPPLY_CHAIN_SNAPSHOT:' || 'S' || sql_stmt_num || ':'
3605: || substrb(sqlerrm,1,62);
3606: return(return_code);
3607: END supply_chain_snapshot;
3608: END CSTPSCCR;