DBA Data[Home] [Help]

APPS.EAM_WO_DEFAULT_PVT dependencies on EAM_PROCESS_WO_PUB

Line 187: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type

183: **********************************************************************/
184:
185:
186: PROCEDURE get_flex_eam_wo
187: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
188: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
189: )
190: IS
191: BEGIN

Line 188: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type

184:
185:
186: PROCEDURE get_flex_eam_wo
187: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
188: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
189: )
190: IS
191: BEGIN
192:

Line 278: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type

274: * attribute with appropriate values.
275: **********************************************************************/
276:
277: PROCEDURE Attribute_Defaulting
278: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
279: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
280: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
281: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
282: , x_return_status OUT NOCOPY VARCHAR2

Line 279: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type

275: **********************************************************************/
276:
277: PROCEDURE Attribute_Defaulting
278: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
279: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
280: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
281: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
282: , x_return_status OUT NOCOPY VARCHAR2
283: )

Line 280: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type

276:
277: PROCEDURE Attribute_Defaulting
278: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
279: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
280: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
281: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
282: , x_return_status OUT NOCOPY VARCHAR2
283: )
284: IS

Line 290: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

286: l_return_status VARCHAR2(2);
287: l_msg_count NUMBER;
288: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
289: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
290: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
291: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
292: l_job_type NUMBER := 1;
293:
294: l_owning_department NUMBER;

Line 319: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

315: l_auto_firm_flag VARCHAR2(10);
316: l_activity_description VARCHAR2(240);
317:
318:
319: l_old_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
320: l_auto_firm_create_flag VARCHAR2(1);
321:
322: /*WO Defaults ER*/
323: l_work_order_type NUMBER;

Line 1049: IF p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_CREATE

1045: p_eam_wo_rec.firm_planned_flag = FND_API.G_MISS_NUM
1046: THEN
1047:
1048: -- Defaulting Firm Planned Flag when auto firm flag on create checked.
1049: IF p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_CREATE
1050: THEN
1051: select nvl(auto_firm_on_create,'N') into l_auto_firm_create_flag
1052: from wip_eam_parameters
1053: where organization_id = p_eam_wo_rec.organization_id;

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

1063:
1064: -- If updating a WO to relesed status and auto_firm_flag is
1065: -- turned on, then firm the WO. Also if WO is created directly
1066: -- in released status and auto firm is ON.
1067: IF (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_UPDATE
1068: and p_eam_wo_rec.status_type = 3 and
1069: l_old_eam_wo_rec.status_type in (1,6,17)
1070: ) OR
1071: (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_CREATE

Line 1071: (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_CREATE

1067: IF (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_UPDATE
1068: and p_eam_wo_rec.status_type = 3 and
1069: l_old_eam_wo_rec.status_type in (1,6,17)
1070: ) OR
1071: (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_CREATE
1072: and p_eam_wo_rec.status_type = 3
1073: )
1074: THEN
1075: select nvl(auto_firm_flag,'N') into l_auto_firm_flag

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

1083:
1084: -- If updating a WO to relesaed status and auto_firm_flag is
1085: -- turned on, then set the WO scheduled dates to the old values
1086: -- . Otherwise, the date encompassment error will be thrown up.
1087: IF (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_UPDATE
1088: and p_eam_wo_rec.status_type = 3
1089: and l_old_eam_wo_rec.status_type in (1,6,17)
1090: and l_auto_firm_flag = 'Y'
1091: )

Line 1211: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type

1207:
1208:
1209:
1210: PROCEDURE Conditional_Defaulting
1211: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1212: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
1213: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
1214: , x_return_status OUT NOCOPY VARCHAR2
1215: )

Line 1212: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type

1208:
1209:
1210: PROCEDURE Conditional_Defaulting
1211: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1212: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
1213: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
1214: , x_return_status OUT NOCOPY VARCHAR2
1215: )
1216: IS

Line 1292: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type

1288: * value from the old record.
1289: * This procedure is not called for CREATE
1290: ********************************************************************/
1291: PROCEDURE Populate_Null_Columns
1292: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1293: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1294: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
1295: )
1296: IS

Line 1293: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type

1289: * This procedure is not called for CREATE
1290: ********************************************************************/
1291: PROCEDURE Populate_Null_Columns
1292: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1293: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1294: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
1295: )
1296: IS
1297: BEGIN

Line 1294: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type

1290: ********************************************************************/
1291: PROCEDURE Populate_Null_Columns
1292: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1293: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1294: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
1295: )
1296: IS
1297: BEGIN
1298: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN