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 461: ( p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type

457: * This procedure is called only when there exists any material in operation 1
458: ********************************************************************/
459:
460: PROCEDURE GetMaterials_In_Op1
461: ( p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
462: , p_organization_id IN NUMBER
463: , p_wip_entity_id IN NUMBER
464: , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
465: )

Line 464: , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type

460: PROCEDURE GetMaterials_In_Op1
461: ( p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
462: , p_organization_id IN NUMBER
463: , p_wip_entity_id IN NUMBER
464: , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
465: )
466: IS
467: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;
468: k NUMBER := l_eam_mat_req_tbl.COUNT ;

Line 467: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;

463: , p_wip_entity_id IN NUMBER
464: , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
465: )
466: IS
467: l_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type := p_eam_mat_req_tbl;
468: k NUMBER := l_eam_mat_req_tbl.COUNT ;
469:
470: CURSOR MaterialREQ IS
471: SELECT

Line 512: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type

508: * and accordingly the department id
509: * This procedure is called only when there exists any material in operation 1
510: ********************************************************************/
511: PROCEDURE Change_OpSeqNum1
512: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
513: , p_operation_seq_num IN NUMBER
514: , p_department_id IN NUMBER
515: , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
516: )

Line 515: , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type

511: PROCEDURE Change_OpSeqNum1
512: ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
513: , p_operation_seq_num IN NUMBER
514: , p_department_id IN NUMBER
515: , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
516: )
517: IS
518: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type := p_eam_mat_req_rec;
519:

Line 518: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type := p_eam_mat_req_rec;

514: , p_department_id IN NUMBER
515: , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
516: )
517: IS
518: l_eam_mat_req_rec EAM_PROCESS_WO_PUB.eam_mat_req_rec_type := p_eam_mat_req_rec;
519:
520: BEGIN
521:
522: IF ( l_eam_mat_req_rec.operation_seq_num = 1 ) THEN