DBA Data[Home] [Help]

APPS.EAM_WO_DEFAULT_PVT dependencies on EAM_PROCESS_WO_PUB

Line 130: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type

126: **********************************************************************/
127:
128:
129: PROCEDURE get_flex_eam_wo
130: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
131: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
132: )
133: IS
134: BEGIN

Line 131: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type

127:
128:
129: PROCEDURE get_flex_eam_wo
130: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
131: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
132: )
133: IS
134: BEGIN
135:

Line 217: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type

213: * attribute with appropriate values.
214: **********************************************************************/
215:
216: PROCEDURE Attribute_Defaulting
217: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
218: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
219: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
220: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
221: , x_return_status OUT NOCOPY VARCHAR2

Line 218: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type

214: **********************************************************************/
215:
216: PROCEDURE Attribute_Defaulting
217: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
218: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
219: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
220: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
221: , x_return_status OUT NOCOPY VARCHAR2
222: )

Line 219: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type

215:
216: PROCEDURE Attribute_Defaulting
217: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
218: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
219: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
220: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
221: , x_return_status OUT NOCOPY VARCHAR2
222: )
223: IS

Line 229: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

225: l_return_status VARCHAR2(2);
226: l_msg_count NUMBER;
227: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
228: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
229: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
230: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
231: l_job_type NUMBER := 1;
232:
233: l_owning_department NUMBER;

Line 258: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

254: l_auto_firm_flag VARCHAR2(10);
255: l_activity_description VARCHAR2(240);
256:
257:
258: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
259: l_auto_firm_create_flag VARCHAR2(1);
260:
261: BEGIN
262:

Line 806: IF p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_CREATE

802: THEN
803: x_eam_wo_rec.firm_planned_flag := 2;
804:
805: -- Defaulting Firm Planned Flag when auto firm flag on create checked.
806: IF p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_CREATE
807: THEN
808: select nvl(auto_firm_on_create,'N') into l_auto_firm_create_flag
809: from wip_eam_parameters
810: where organization_id = p_eam_wo_rec.organization_id;

Line 822: IF (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_UPDATE

818:
819: -- If updating a WO to relesed status and auto_firm_flag is
820: -- turned on, then firm the WO. Also if WO is created directly
821: -- in released status and auto firm is ON.
822: IF (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_UPDATE
823: and p_eam_wo_rec.status_type = 3 and
824: l_old_eam_wo_rec.status_type in (1,6,17)
825: ) OR
826: (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_CREATE

Line 826: (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_CREATE

822: IF (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_UPDATE
823: and p_eam_wo_rec.status_type = 3 and
824: l_old_eam_wo_rec.status_type in (1,6,17)
825: ) OR
826: (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_CREATE
827: and p_eam_wo_rec.status_type = 3
828: )
829: THEN
830: select nvl(auto_firm_flag,'N') into l_auto_firm_flag

Line 842: IF (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_UPDATE

838:
839: -- If updating a WO to relesaed status and auto_firm_flag is
840: -- turned on, then set the WO scheduled dates to the old values
841: -- . Otherwise, the date encompassment error will be thrown up.
842: IF (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_UPDATE
843: and p_eam_wo_rec.status_type = 3
844: and l_old_eam_wo_rec.status_type in (1,6,17)
845: and l_auto_firm_flag = 'Y'
846: )

Line 959: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type

955:
956:
957:
958: PROCEDURE Conditional_Defaulting
959: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
960: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
961: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
962: , x_return_status OUT NOCOPY VARCHAR2
963: )

Line 960: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type

956:
957:
958: PROCEDURE Conditional_Defaulting
959: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
960: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
961: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
962: , x_return_status OUT NOCOPY VARCHAR2
963: )
964: IS

Line 1033: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type

1029: * value from the old record.
1030: * This procedure is not called for CREATE
1031: ********************************************************************/
1032: PROCEDURE Populate_Null_Columns
1033: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1034: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1035: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
1036: )
1037: IS

Line 1034: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type

1030: * This procedure is not called for CREATE
1031: ********************************************************************/
1032: PROCEDURE Populate_Null_Columns
1033: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1034: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1035: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
1036: )
1037: IS
1038: BEGIN

Line 1035: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type

1031: ********************************************************************/
1032: PROCEDURE Populate_Null_Columns
1033: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1034: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1035: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
1036: )
1037: IS
1038: BEGIN
1039: x_eam_wo_rec := p_eam_wo_rec;