17: -------------------------------------------------------------------------------
18:
19: PROCEDURE Process_MatCost(
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
22: p_commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
24: x_return_status OUT NOCOPY VARCHAR2,
25: x_msg_count OUT NOCOPY NUMBER,
18:
19: PROCEDURE Process_MatCost(
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
22: p_commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
24: x_return_status OUT NOCOPY VARCHAR2,
25: x_msg_count OUT NOCOPY NUMBER,
26: x_msg_data OUT NOCOPY VARCHAR2,
19: PROCEDURE Process_MatCost(
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
22: p_commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
24: x_return_status OUT NOCOPY VARCHAR2,
25: x_msg_count OUT NOCOPY NUMBER,
26: x_msg_data OUT NOCOPY VARCHAR2,
27: p_txn_id IN NUMBER,
49: -------------------------------------------------------------------------------
50:
51: PROCEDURE Process_ResCost(
52: p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE,
55: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
50:
51: PROCEDURE Process_ResCost(
52: p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE,
55: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
58: x_msg_data OUT NOCOPY VARCHAR2,
51: PROCEDURE Process_ResCost(
52: p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE,
55: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
58: x_msg_data OUT NOCOPY VARCHAR2,
59: p_group_id IN NUMBER,
92: ---------------------------------------------------------------------------------------
93:
94: PROCEDURE Update_eamCost (
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
93:
94: PROCEDURE Update_eamCost (
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
94: PROCEDURE Update_eamCost (
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_txn_mode IN NUMBER, -- 1=material 2=resource
154: ------------------------------------------------------------------------------
155:
156: PROCEDURE InsertUpdate_eamPerBal (
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
159: p_commit IN VARCHAR2 := FND_API.G_FALSE,
160: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
155:
156: PROCEDURE InsertUpdate_eamPerBal (
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
159: p_commit IN VARCHAR2 := FND_API.G_FALSE,
160: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
156: PROCEDURE InsertUpdate_eamPerBal (
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
159: p_commit IN VARCHAR2 := FND_API.G_FALSE,
160: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: p_period_id IN NUMBER := null,
218: ------------------------------------------------------------------------------
219:
220: PROCEDURE InsertUpdate_assetPerBal (
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
223: p_commit IN VARCHAR2 := FND_API.G_FALSE,
224: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
219:
220: PROCEDURE InsertUpdate_assetPerBal (
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
223: p_commit IN VARCHAR2 := FND_API.G_FALSE,
224: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
220: PROCEDURE InsertUpdate_assetPerBal (
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
223: p_commit IN VARCHAR2 := FND_API.G_FALSE,
224: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_period_id IN NUMBER := null,
311: /* ======================================================================= */
312:
313: PROCEDURE Delete_eamPerBal (
314: p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,
312:
313: PROCEDURE Delete_eamPerBal (
314: p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,
320: x_msg_data OUT NOCOPY VARCHAR2,
313: PROCEDURE Delete_eamPerBal (
314: p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,
320: x_msg_data OUT NOCOPY VARCHAR2,
321: p_entity_id_tab IN CSTPECEP.wip_entity_id_type,
342:
343: PROCEDURE Compute_Job_Estimate (
344: p_api_version IN NUMBER,
345: p_init_msg_list IN VARCHAR2
346: := FND_API.G_FALSE,
347: p_commit IN VARCHAR2
348: := FND_API.G_FALSE,
349: p_validation_level IN NUMBER
350: := FND_API.G_VALID_LEVEL_FULL,
344: p_api_version IN NUMBER,
345: p_init_msg_list IN VARCHAR2
346: := FND_API.G_FALSE,
347: p_commit IN VARCHAR2
348: := FND_API.G_FALSE,
349: p_validation_level IN NUMBER
350: := FND_API.G_VALID_LEVEL_FULL,
351: p_debug IN VARCHAR2 := 'N',
352: p_wip_entity_id IN NUMBER,
346: := FND_API.G_FALSE,
347: p_commit IN VARCHAR2
348: := FND_API.G_FALSE,
349: p_validation_level IN NUMBER
350: := FND_API.G_VALID_LEVEL_FULL,
351: p_debug IN VARCHAR2 := 'N',
352: p_wip_entity_id IN NUMBER,
353:
354: p_user_id IN NUMBER,
376: -- 04/17/01 Terence Chan Genesis --
377: ----------------------------------------------------------------------------
378: PROCEDURE Rollup_Cost (
379: p_api_version IN NUMBER,
380: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
381: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
382: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
383: x_return_status OUT NOCOPY VARCHAR2 ,
384: x_msg_count OUT NOCOPY NUMBER ,
377: ----------------------------------------------------------------------------
378: PROCEDURE Rollup_Cost (
379: p_api_version IN NUMBER,
380: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
381: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
382: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
383: x_return_status OUT NOCOPY VARCHAR2 ,
384: x_msg_count OUT NOCOPY NUMBER ,
385: x_msg_data OUT NOCOPY VARCHAR2 ,
378: PROCEDURE Rollup_Cost (
379: p_api_version IN NUMBER,
380: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
381: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
382: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
383: x_return_status OUT NOCOPY VARCHAR2 ,
384: x_msg_count OUT NOCOPY NUMBER ,
385: x_msg_data OUT NOCOPY VARCHAR2 ,
386:
409: -- 04/17/01 Terence Chan Genesis --
410: ----------------------------------------------------------------------------
411: PROCEDURE Purge_Rollup_Cost (
412: p_api_version IN NUMBER,
413: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
414: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
415: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
416: x_return_status OUT NOCOPY VARCHAR2 ,
417: x_msg_count OUT NOCOPY NUMBER ,
410: ----------------------------------------------------------------------------
411: PROCEDURE Purge_Rollup_Cost (
412: p_api_version IN NUMBER,
413: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
414: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
415: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
416: x_return_status OUT NOCOPY VARCHAR2 ,
417: x_msg_count OUT NOCOPY NUMBER ,
418: x_msg_data OUT NOCOPY VARCHAR2 ,
411: PROCEDURE Purge_Rollup_Cost (
412: p_api_version IN NUMBER,
413: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
414: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
415: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
416: x_return_status OUT NOCOPY VARCHAR2 ,
417: x_msg_count OUT NOCOPY NUMBER ,
418: x_msg_data OUT NOCOPY VARCHAR2 ,
419:
438: ----------------------------------------------------------------------------
439:
440: PROCEDURE check_if_direct_item (
441: p_api_version IN NUMBER,
442: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
443: p_commit IN VARCHAR2 := FND_API.G_FALSE,
444: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
445:
446: p_interface_txn_id IN NUMBER,
439:
440: PROCEDURE check_if_direct_item (
441: p_api_version IN NUMBER,
442: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
443: p_commit IN VARCHAR2 := FND_API.G_FALSE,
444: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
445:
446: p_interface_txn_id IN NUMBER,
447:
440: PROCEDURE check_if_direct_item (
441: p_api_version IN NUMBER,
442: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
443: p_commit IN VARCHAR2 := FND_API.G_FALSE,
444: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
445:
446: p_interface_txn_id IN NUMBER,
447:
448: x_direct_item_flag OUT NOCOPY NUMBER,
466: ----------------------------------------------------------------------------
467:
468: PROCEDURE process_direct_item_txn (
469: p_api_version IN NUMBER,
470: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
471: p_commit IN VARCHAR2 := FND_API.G_FALSE,
472: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
473:
474: p_directItem_rec IN WIP_Transaction_PUB.Res_Rec_Type,
467:
468: PROCEDURE process_direct_item_txn (
469: p_api_version IN NUMBER,
470: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
471: p_commit IN VARCHAR2 := FND_API.G_FALSE,
472: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
473:
474: p_directItem_rec IN WIP_Transaction_PUB.Res_Rec_Type,
475:
468: PROCEDURE process_direct_item_txn (
469: p_api_version IN NUMBER,
470: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
471: p_commit IN VARCHAR2 := FND_API.G_FALSE,
472: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
473:
474: p_directItem_rec IN WIP_Transaction_PUB.Res_Rec_Type,
475:
476: x_directItem_rec IN OUT NOCOPY WIP_Transaction_PUB.Res_Rec_Type,
496: -- 05/01/01 Anitha Dixit Created --
497: ----------------------------------------------------------------------------
498: PROCEDURE cost_direct_item_txn (
499: p_api_version IN NUMBER,
500: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
501: p_commit IN VARCHAR2 := FND_API.G_FALSE,
502: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
503:
504: p_group_id IN NUMBER,
497: ----------------------------------------------------------------------------
498: PROCEDURE cost_direct_item_txn (
499: p_api_version IN NUMBER,
500: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
501: p_commit IN VARCHAR2 := FND_API.G_FALSE,
502: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
503:
504: p_group_id IN NUMBER,
505: p_prg_appl_id IN NUMBER,
498: PROCEDURE cost_direct_item_txn (
499: p_api_version IN NUMBER,
500: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
501: p_commit IN VARCHAR2 := FND_API.G_FALSE,
502: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
503:
504: p_group_id IN NUMBER,
505: p_prg_appl_id IN NUMBER,
506: p_prg_id IN NUMBER,
531: -- parameter --
532: ----------------------------------------------------------------------------
533: PROCEDURE insert_direct_item_distr (
534: p_api_version IN NUMBER,
535: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
536: p_commit IN VARCHAR2 := FND_API.G_FALSE,
537: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
538:
539: p_txn_id IN NUMBER,
532: ----------------------------------------------------------------------------
533: PROCEDURE insert_direct_item_distr (
534: p_api_version IN NUMBER,
535: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
536: p_commit IN VARCHAR2 := FND_API.G_FALSE,
537: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
538:
539: p_txn_id IN NUMBER,
540: p_ref_acct IN NUMBER,
533: PROCEDURE insert_direct_item_distr (
534: p_api_version IN NUMBER,
535: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
536: p_commit IN VARCHAR2 := FND_API.G_FALSE,
537: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
538:
539: p_txn_id IN NUMBER,
540: p_ref_acct IN NUMBER,
541: p_txn_value IN NUMBER,
568: -- 07/18/01 Anitha Dixit Created --
569: ----------------------------------------------------------------------------
570: PROCEDURE update_wip_period_balances (
571: p_api_version IN NUMBER,
572: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
573: p_commit IN VARCHAR2 := FND_API.G_FALSE,
574: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
575:
576: p_wip_entity_id IN NUMBER,
569: ----------------------------------------------------------------------------
570: PROCEDURE update_wip_period_balances (
571: p_api_version IN NUMBER,
572: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
573: p_commit IN VARCHAR2 := FND_API.G_FALSE,
574: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
575:
576: p_wip_entity_id IN NUMBER,
577: p_acct_period_id IN NUMBER,
570: PROCEDURE update_wip_period_balances (
571: p_api_version IN NUMBER,
572: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
573: p_commit IN VARCHAR2 := FND_API.G_FALSE,
574: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
575:
576: p_wip_entity_id IN NUMBER,
577: p_acct_period_id IN NUMBER,
578: p_txn_id IN NUMBER,
600: -- 05/01/01 Anitha Dixit Created --
601: ----------------------------------------------------------------------------
602: PROCEDURE insert_direct_item_txn (
603: p_api_version IN NUMBER,
604: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
605: p_commit IN VARCHAR2 := FND_API.G_FALSE,
606: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
607:
608: p_group_id IN NUMBER,
601: ----------------------------------------------------------------------------
602: PROCEDURE insert_direct_item_txn (
603: p_api_version IN NUMBER,
604: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
605: p_commit IN VARCHAR2 := FND_API.G_FALSE,
606: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
607:
608: p_group_id IN NUMBER,
609: p_prg_appl_id IN NUMBER,
602: PROCEDURE insert_direct_item_txn (
603: p_api_version IN NUMBER,
604: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
605: p_commit IN VARCHAR2 := FND_API.G_FALSE,
606: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
607:
608: p_group_id IN NUMBER,
609: p_prg_appl_id IN NUMBER,
610: p_prg_id IN NUMBER,
643: ----------------------------------------------------------------------------
644: PROCEDURE get_Direct_Item_Charge_Acct (
645: p_api_version IN NUMBER,
646: p_init_msg_list IN VARCHAR2
647: := FND_API.G_FALSE,
648: p_commit IN VARCHAR2
649: := FND_API.G_FALSE,
650: p_validation_level IN NUMBER
651: := FND_API.G_VALID_LEVEL_FULL,
645: p_api_version IN NUMBER,
646: p_init_msg_list IN VARCHAR2
647: := FND_API.G_FALSE,
648: p_commit IN VARCHAR2
649: := FND_API.G_FALSE,
650: p_validation_level IN NUMBER
651: := FND_API.G_VALID_LEVEL_FULL,
652: p_wip_entity_id IN NUMBER DEFAULT NULL,
653: x_material_acct OUT NOCOPY NUMBER,
647: := FND_API.G_FALSE,
648: p_commit IN VARCHAR2
649: := FND_API.G_FALSE,
650: p_validation_level IN NUMBER
651: := FND_API.G_VALID_LEVEL_FULL,
652: p_wip_entity_id IN NUMBER DEFAULT NULL,
653: x_material_acct OUT NOCOPY NUMBER,
654: x_return_status OUT NOCOPY VARCHAR2,
655: x_msg_count OUT NOCOPY NUMBER,
674: -- 08/26/01 Anitha Dixit Created --
675: ----------------------------------------------------------------------------
676: PROCEDURE validate_for_reestimation (
677: p_api_version IN NUMBER,
678: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
679: p_commit IN VARCHAR2 := fnd_api.g_false,
680: p_validation_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full,
681:
682: p_wip_entity_id IN NUMBER,
675: ----------------------------------------------------------------------------
676: PROCEDURE validate_for_reestimation (
677: p_api_version IN NUMBER,
678: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
679: p_commit IN VARCHAR2 := fnd_api.g_false,
680: p_validation_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full,
681:
682: p_wip_entity_id IN NUMBER,
683: p_job_status IN NUMBER,
676: PROCEDURE validate_for_reestimation (
677: p_api_version IN NUMBER,
678: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
679: p_commit IN VARCHAR2 := fnd_api.g_false,
680: p_validation_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full,
681:
682: p_wip_entity_id IN NUMBER,
683: p_job_status IN NUMBER,
684: p_curr_est_status IN NUMBER,
712: -- 09/26/02 Hemant G Created --
713: ----------------------------------------------------------------------------
714: PROCEDURE Redistribute_WIP_Accounts (
715: p_api_version IN NUMBER,
716: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
717: p_commit IN VARCHAR2 := FND_API.G_FALSE,
718: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
719: p_wcti_group_id IN NUMBER,
720:
713: ----------------------------------------------------------------------------
714: PROCEDURE Redistribute_WIP_Accounts (
715: p_api_version IN NUMBER,
716: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
717: p_commit IN VARCHAR2 := FND_API.G_FALSE,
718: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
719: p_wcti_group_id IN NUMBER,
720:
721: p_user_id IN NUMBER,
714: PROCEDURE Redistribute_WIP_Accounts (
715: p_api_version IN NUMBER,
716: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
717: p_commit IN VARCHAR2 := FND_API.G_FALSE,
718: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
719: p_wcti_group_id IN NUMBER,
720:
721: p_user_id IN NUMBER,
722: p_request_id IN NUMBER,
747: -- 11/26/02 Ray Thng Created --
748: ----------------------------------------------------------------------------
749: PROCEDURE get_charge_asset (
750: p_api_version IN NUMBER,
751: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
752: p_wip_entity_id IN NUMBER,
753: x_inventory_item_id OUT NOCOPY csi_item_instances.inventory_item_id%TYPE,
754: x_serial_number OUT NOCOPY csi_item_instances.serial_number%TYPE,
755: x_maintenance_object_id OUT NOCOPY mtl_serial_numbers.gen_object_id%TYPE,
773: -- called from PAC code. eAM support in PAC --
774: ----------------------------------------------------------------------------
775: PROCEDURE get_CostEle_for_DirectItem (
776: p_api_version IN NUMBER,
777: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
778: p_commit IN VARCHAR2 := FND_API.G_FALSE,
779: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
780: p_txn_id IN NUMBER,
781: p_mnt_or_mfg IN NUMBER, -- 1: eam cost element,
774: ----------------------------------------------------------------------------
775: PROCEDURE get_CostEle_for_DirectItem (
776: p_api_version IN NUMBER,
777: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
778: p_commit IN VARCHAR2 := FND_API.G_FALSE,
779: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
780: p_txn_id IN NUMBER,
781: p_mnt_or_mfg IN NUMBER, -- 1: eam cost element,
782: -- 2: manufacturing cost ele
775: PROCEDURE get_CostEle_for_DirectItem (
776: p_api_version IN NUMBER,
777: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
778: p_commit IN VARCHAR2 := FND_API.G_FALSE,
779: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
780: p_txn_id IN NUMBER,
781: p_mnt_or_mfg IN NUMBER, -- 1: eam cost element,
782: -- 2: manufacturing cost ele
783: p_pac_or_perp IN NUMBER := 0, -- 1 for PAC, 0 for Perpetual
799: -- 06/26/03 Linda Soo Created --
800: ----------------------------------------------------------------------------
801: PROCEDURE get_ExpType_for_DirectItem (
802: p_api_version IN NUMBER,
803: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
804: p_commit IN VARCHAR2 := FND_API.G_FALSE,
805: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
806: p_txn_id IN NUMBER,
807: x_expenditure_type OUT NOCOPY VARCHAR2,
800: ----------------------------------------------------------------------------
801: PROCEDURE get_ExpType_for_DirectItem (
802: p_api_version IN NUMBER,
803: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
804: p_commit IN VARCHAR2 := FND_API.G_FALSE,
805: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
806: p_txn_id IN NUMBER,
807: x_expenditure_type OUT NOCOPY VARCHAR2,
808: x_return_status OUT NOCOPY VARCHAR2,
801: PROCEDURE get_ExpType_for_DirectItem (
802: p_api_version IN NUMBER,
803: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
804: p_commit IN VARCHAR2 := FND_API.G_FALSE,
805: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
806: p_txn_id IN NUMBER,
807: x_expenditure_type OUT NOCOPY VARCHAR2,
808: x_return_status OUT NOCOPY VARCHAR2,
809: x_msg_count OUT NOCOPY NUMBER,
821: -- http://www-apps.us.oracle.com:1100/cst/project/rel11i.10proj/WOCR/ --
822: ----------------------------------------------------------------------------
823: PROCEDURE Rollup_WorkOrderCost (
824: p_api_version IN NUMBER,
825: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
826: p_commit IN VARCHAR2 := FND_API.G_FALSE,
827: p_group_id IN NUMBER,
828: p_organization_id IN NUMBER,
829: p_user_id IN NUMBER,
822: ----------------------------------------------------------------------------
823: PROCEDURE Rollup_WorkOrderCost (
824: p_api_version IN NUMBER,
825: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
826: p_commit IN VARCHAR2 := FND_API.G_FALSE,
827: p_group_id IN NUMBER,
828: p_organization_id IN NUMBER,
829: p_user_id IN NUMBER,
830: p_prog_appl_id IN NUMBER,
841: -- http://www-apps.us.oracle.com:1100/cst/project/rel11i.10proj/WOCR/ --
842: ----------------------------------------------------------------------------
843: PROCEDURE Purge_RollupCost (
844: p_api_version IN NUMBER,
845: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
846: p_commit IN VARCHAR2 := FND_API.G_FALSE,
847: p_group_id IN NUMBER := NULL,
848: p_prog_appl_id IN NUMBER := NULL,
849: p_last_update_date IN DATE := NULL,
842: ----------------------------------------------------------------------------
843: PROCEDURE Purge_RollupCost (
844: p_api_version IN NUMBER,
845: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
846: p_commit IN VARCHAR2 := FND_API.G_FALSE,
847: p_group_id IN NUMBER := NULL,
848: p_prog_appl_id IN NUMBER := NULL,
849: p_last_update_date IN DATE := NULL,
850: x_return_status OUT NOCOPY VARCHAR2);
990: -------------------------------------------------------------------------------
991: PROCEDURE Insert_tempEstimateDetails
992: (
993: p_api_version IN NUMBER,
994: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
995: p_commit IN VARCHAR2 := FND_API.G_FALSE,
996: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
997: x_return_status OUT NOCOPY VARCHAR2,
998: x_msg_count OUT NOCOPY NUMBER,
991: PROCEDURE Insert_tempEstimateDetails
992: (
993: p_api_version IN NUMBER,
994: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
995: p_commit IN VARCHAR2 := FND_API.G_FALSE,
996: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
997: x_return_status OUT NOCOPY VARCHAR2,
998: x_msg_count OUT NOCOPY NUMBER,
999: x_msg_data OUT NOCOPY VARCHAR2,
992: (
993: p_api_version IN NUMBER,
994: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
995: p_commit IN VARCHAR2 := FND_API.G_FALSE,
996: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
997: x_return_status OUT NOCOPY VARCHAR2,
998: x_msg_count OUT NOCOPY NUMBER,
999: x_msg_data OUT NOCOPY VARCHAR2,
1000: p_entity_id_tab IN CSTPECEP.wip_entity_id_type