DBA Data[Home] [Help]

APPS.EAM_MAT_REQ_DEFAULT_PVT dependencies on EAM_PROCESS_WO_PUB

Line 32: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type

28: **********************************************************************/
29:
30:
31: PROCEDURE get_flex_eam_mat_req
32: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
33: , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
34: )
35: IS
36: BEGIN

Line 33: , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type

29:
30:
31: PROCEDURE get_flex_eam_mat_req
32: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
33: , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
34: )
35: IS
36: BEGIN
37:

Line 119: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type

115: * attribute with appropriate values.
116: **********************************************************************/
117:
118: PROCEDURE Attribute_Defaulting
119: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
120: , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
121: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
122: , x_return_status OUT NOCOPY VARCHAR2
123: )

Line 120: , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type

116: **********************************************************************/
117:
118: PROCEDURE Attribute_Defaulting
119: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
120: , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
121: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
122: , x_return_status OUT NOCOPY VARCHAR2
123: )
124: IS

Line 125: l_out_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;

121: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
122: , x_return_status OUT NOCOPY VARCHAR2
123: )
124: IS
125: l_out_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type;
126: BEGIN
127:
128: x_eam_mat_req_rec := p_eam_mat_req_rec;
129: -- x_eam_mat_req_rec := p_eam_mat_req_rec;

Line 221: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type

217: * value from the old record.
218: * This procedure is not called for CREATE
219: ********************************************************************/
220: PROCEDURE Populate_Null_Columns
221: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
222: , p_old_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
223: , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
224: )
225: IS

Line 222: , p_old_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type

218: * This procedure is not called for CREATE
219: ********************************************************************/
220: PROCEDURE Populate_Null_Columns
221: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
222: , p_old_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
223: , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
224: )
225: IS
226: BEGIN

Line 223: , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type

219: ********************************************************************/
220: PROCEDURE Populate_Null_Columns
221: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
222: , p_old_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
223: , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
224: )
225: IS
226: BEGIN
227: x_eam_mat_req_rec := p_eam_mat_req_rec;

Line 527: ( p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type

523: * This procedure is called only when there exists any material in operation 1
524: ********************************************************************/
525:
526: PROCEDURE GetMaterials_In_Op1
527: ( p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
528: , p_organization_id IN NUMBER
529: , p_wip_entity_id IN NUMBER
530: , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
531: )

Line 530: , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type

526: PROCEDURE GetMaterials_In_Op1
527: ( p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
528: , p_organization_id IN NUMBER
529: , p_wip_entity_id IN NUMBER
530: , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
531: )
532: IS
533: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;
534: k NUMBER := l_eam_mat_req_tbl.COUNT ;

Line 533: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;

529: , p_wip_entity_id IN NUMBER
530: , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
531: )
532: IS
533: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;
534: k NUMBER := l_eam_mat_req_tbl.COUNT ;
535:
536: CURSOR MaterialREQ IS
537: SELECT

Line 578: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type

574: * and accordingly the department id
575: * This procedure is called only when there exists any material in operation 1
576: ********************************************************************/
577: PROCEDURE Change_OpSeqNum1
578: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
579: , p_operation_seq_num IN NUMBER
580: , p_department_id IN NUMBER
581: , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
582: )

Line 581: , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type

577: PROCEDURE Change_OpSeqNum1
578: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
579: , p_operation_seq_num IN NUMBER
580: , p_department_id IN NUMBER
581: , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
582: )
583: IS
584: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type := p_eam_mat_req_rec;
585:

Line 584: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type := p_eam_mat_req_rec;

580: , p_department_id IN NUMBER
581: , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
582: )
583: IS
584: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type := p_eam_mat_req_rec;
585:
586: BEGIN
587:
588: IF ( l_eam_mat_req_rec.operation_seq_num = 1 ) THEN