[Home] [Help]
11: -- 115.3 02/21/00 pkdas Changed the name of the procedure Insert_From_Form
12: -- to Create_Repairs and Update_From_Form to Update_Repairs.
13: -- Added p_REPAIR_LINE_ID and p_REPAIR_NUMBER as IN
14: -- parameters in the Create_Repairs procedure.
15: -- Added standard OUT parameter in the Create_Repairs
16: -- and Update_Repairs procedures. Added default values
17: -- to the parameters.
18: -- 115.4 02/29/00 pkdas Changed the procedure name
19: -- Create_Repairs -> Create_Repair_Order
128: l_repln_rec csd_repairs_pub.repln_rec_type;
129: --
130: begin
131: --
132: -- Standard Start of API savepoint
133: SAVEPOINT CREATE_REPAIR_ORDER_GRP;
134: --
135: -- Initialize message list if p_init_msg_list is set to TRUE.
136: IF FND_API.to_Boolean(p_init_msg_list)
252: END IF;
253: --
254: -- End of API body.
255: --
256: -- Standard check for p_commit
257: IF FND_API.to_Boolean(p_commit)
258: THEN
259: COMMIT WORK;
260: END IF;
257: IF FND_API.to_Boolean(p_commit)
258: THEN
259: COMMIT WORK;
260: END IF;
261: -- Standard call to get message count and if count is 1, get message info.
262: FND_MSG_PUB.Count_And_Get
263: (p_count => x_msg_count,
264: p_data => x_msg_data
265: );
392: l_repln_rec csd_repairs_pub.repln_rec_type;
393: --
394: begin
395: --
396: -- Standard Start of API savepoint
397: SAVEPOINT UPDATE_REPAIR_ORDER_GRP;
398: --
399: -- Initialize message list if p_init_msg_list is set to TRUE.
400: IF FND_API.to_Boolean( p_init_msg_list )
508: END IF;
509: --
510: -- End of API body.
511: --
512: -- Standard check for p_commit
513: IF FND_API.to_Boolean( p_commit )
514: THEN
515: COMMIT WORK;
516: END IF;
513: IF FND_API.to_Boolean( p_commit )
514: THEN
515: COMMIT WORK;
516: END IF;
517: -- Standard call to get message count and if count is 1, get message info.
518: FND_MSG_PUB.Count_And_Get
519: (p_count => x_msg_count,
520: p_data => x_msg_data
521: );
592:
593: --
594: BEGIN
595: --
596: -- Standard Start of API savepoint
597: SAVEPOINT UPDATE_APPROVAL_STATUS_GRP;
598: --
599: -- Initialize API return status to success
600: x_return_status := FND_API.G_RET_STS_SUCCESS;
785: -- End of API body.
786: --
787: -- travi commit;
788: --
789: -- Standard call to get message count and if count is 1, get message info.
790: FND_MSG_PUB.Count_And_Get
791: (p_count => x_msg_count,
792: p_data => x_msg_data
793: );
848:
849: --
850: BEGIN
851: --
852: -- Standard Start of API savepoint
853: SAVEPOINT UPDATE_STATUS_GRP;
854: --
855: -- Initialize API return status to success
856: x_return_status := FND_API.G_RET_STS_SUCCESS;
1018: END IF;
1019: --
1020: -- travi commit;
1021: --
1022: -- Standard call to get message count and if count is 1, get message info.
1023: FND_MSG_PUB.Count_And_Get
1024: (p_count => x_msg_count,
1025: p_data => x_msg_data
1026: );
1120: --
1121: BEGIN
1122: --
1123: -----------------------------------
1124: -- Standard Start of API savepoint
1125: -----------------------------------
1126: SAVEPOINT UPDATE_GRP_APPV_STATUS;
1127:
1128: -----------------------------------------------------
1125: -----------------------------------
1126: SAVEPOINT UPDATE_GRP_APPV_STATUS;
1127:
1128: -----------------------------------------------------
1129: -- Standard call to check for call compatibility.
1130: -----------------------------------------------------
1131: IF NOT FND_API.Compatible_API_Call (l_api_version,
1132: p_api_version,
1133: l_api_name ,
1365: -- update to group is done in the call csd_repair_estimate_pvt.update_repair_estimate
1366: -- repair group object version number is not returned in this case
1367:
1368: -------------------------------
1369: -- Standard check for p_commit
1370: -------------------------------
1371: IF FND_API.to_Boolean(p_commit)
1372: THEN
1373: COMMIT;
1373: COMMIT;
1374: END IF;
1375:
1376: ---------------------------------------------------------------------------
1377: -- Standard call to get message count and if count is 1, get message info.
1378: ---------------------------------------------------------------------------
1379: FND_MSG_PUB.Count_And_Get
1380: (p_count => x_msg_count,
1381: p_data => x_msg_data);
1468: --
1469: BEGIN
1470: --
1471: -----------------------------------
1472: -- Standard Start of API savepoint
1473: -----------------------------------
1474: SAVEPOINT UPDATE_GRP_REJT_STATUS;
1475:
1476: -----------------------------------------------------
1473: -----------------------------------
1474: SAVEPOINT UPDATE_GRP_REJT_STATUS;
1475:
1476: -----------------------------------------------------
1477: -- Standard call to check for call compatibility.
1478: -----------------------------------------------------
1479: IF NOT FND_API.Compatible_API_Call (l_api_version,
1480: p_api_version,
1481: l_api_name ,
1713: -- update to group is done in the call csd_repair_estimate_pvt.update_repair_estimate
1714: -- repair group object version number is not returned in this case
1715:
1716: -------------------------------
1717: -- Standard check for p_commit
1718: -------------------------------
1719: IF FND_API.to_Boolean(p_commit)
1720: THEN
1721: COMMIT;
1721: COMMIT;
1722: END IF;
1723:
1724: ---------------------------------------------------------------------------
1725: -- Standard call to get message count and if count is 1, get message info.
1726: ---------------------------------------------------------------------------
1727: FND_MSG_PUB.Count_And_Get
1728: (p_count => x_msg_count,
1729: p_data => x_msg_data