[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
127: l_repln_rec csd_repairs_pub.repln_rec_type;
128: --
129: begin
130: --
131: -- Standard Start of API savepoint
132: SAVEPOINT CREATE_REPAIR_ORDER_GRP;
133: --
134: -- Initialize message list if p_init_msg_list is set to TRUE.
135: IF FND_API.to_Boolean(p_init_msg_list)
250: END IF;
251: --
252: -- End of API body.
253: --
254: -- Standard check for p_commit
255: IF FND_API.to_Boolean(p_commit)
256: THEN
257: COMMIT WORK;
258: END IF;
255: IF FND_API.to_Boolean(p_commit)
256: THEN
257: COMMIT WORK;
258: END IF;
259: -- Standard call to get message count and if count is 1, get message info.
260: FND_MSG_PUB.Count_And_Get
261: (p_count => x_msg_count,
262: p_data => x_msg_data
263: );
389: l_repln_rec csd_repairs_pub.repln_rec_type;
390: --
391: begin
392: --
393: -- Standard Start of API savepoint
394: SAVEPOINT UPDATE_REPAIR_ORDER_GRP;
395: --
396: -- Initialize message list if p_init_msg_list is set to TRUE.
397: IF FND_API.to_Boolean( p_init_msg_list )
504: END IF;
505: --
506: -- End of API body.
507: --
508: -- Standard check for p_commit
509: IF FND_API.to_Boolean( p_commit )
510: THEN
511: COMMIT WORK;
512: END IF;
509: IF FND_API.to_Boolean( p_commit )
510: THEN
511: COMMIT WORK;
512: END IF;
513: -- Standard call to get message count and if count is 1, get message info.
514: FND_MSG_PUB.Count_And_Get
515: (p_count => x_msg_count,
516: p_data => x_msg_data
517: );
588:
589: --
590: BEGIN
591: --
592: -- Standard Start of API savepoint
593: SAVEPOINT UPDATE_APPROVAL_STATUS_GRP;
594: --
595: -- Initialize API return status to success
596: x_return_status := FND_API.G_RET_STS_SUCCESS;
781: -- End of API body.
782: --
783: -- travi commit;
784: --
785: -- Standard call to get message count and if count is 1, get message info.
786: FND_MSG_PUB.Count_And_Get
787: (p_count => x_msg_count,
788: p_data => x_msg_data
789: );
844:
845: --
846: BEGIN
847: --
848: -- Standard Start of API savepoint
849: SAVEPOINT UPDATE_STATUS_GRP;
850: --
851: -- Initialize API return status to success
852: x_return_status := FND_API.G_RET_STS_SUCCESS;
1014: END IF;
1015: --
1016: -- travi commit;
1017: --
1018: -- Standard call to get message count and if count is 1, get message info.
1019: FND_MSG_PUB.Count_And_Get
1020: (p_count => x_msg_count,
1021: p_data => x_msg_data
1022: );
1116: --
1117: BEGIN
1118: --
1119: -----------------------------------
1120: -- Standard Start of API savepoint
1121: -----------------------------------
1122: SAVEPOINT UPDATE_GRP_APPV_STATUS;
1123:
1124: -----------------------------------------------------
1121: -----------------------------------
1122: SAVEPOINT UPDATE_GRP_APPV_STATUS;
1123:
1124: -----------------------------------------------------
1125: -- Standard call to check for call compatibility.
1126: -----------------------------------------------------
1127: IF NOT FND_API.Compatible_API_Call (l_api_version,
1128: p_api_version,
1129: l_api_name ,
1361: -- update to group is done in the call csd_repair_estimate_pvt.update_repair_estimate
1362: -- repair group object version number is not returned in this case
1363:
1364: -------------------------------
1365: -- Standard check for p_commit
1366: -------------------------------
1367: IF FND_API.to_Boolean(p_commit)
1368: THEN
1369: COMMIT;
1369: COMMIT;
1370: END IF;
1371:
1372: ---------------------------------------------------------------------------
1373: -- Standard call to get message count and if count is 1, get message info.
1374: ---------------------------------------------------------------------------
1375: FND_MSG_PUB.Count_And_Get
1376: (p_count => x_msg_count,
1377: p_data => x_msg_data);
1464: --
1465: BEGIN
1466: --
1467: -----------------------------------
1468: -- Standard Start of API savepoint
1469: -----------------------------------
1470: SAVEPOINT UPDATE_GRP_REJT_STATUS;
1471:
1472: -----------------------------------------------------
1469: -----------------------------------
1470: SAVEPOINT UPDATE_GRP_REJT_STATUS;
1471:
1472: -----------------------------------------------------
1473: -- Standard call to check for call compatibility.
1474: -----------------------------------------------------
1475: IF NOT FND_API.Compatible_API_Call (l_api_version,
1476: p_api_version,
1477: l_api_name ,
1709: -- update to group is done in the call csd_repair_estimate_pvt.update_repair_estimate
1710: -- repair group object version number is not returned in this case
1711:
1712: -------------------------------
1713: -- Standard check for p_commit
1714: -------------------------------
1715: IF FND_API.to_Boolean(p_commit)
1716: THEN
1717: COMMIT;
1717: COMMIT;
1718: END IF;
1719:
1720: ---------------------------------------------------------------------------
1721: -- Standard call to get message count and if count is 1, get message info.
1722: ---------------------------------------------------------------------------
1723: FND_MSG_PUB.Count_And_Get
1724: (p_count => x_msg_count,
1725: p_data => x_msg_data