DBA Data[Home] [Help]

APPS.AHL_MEL_CDL_ATA_SEQS_PVT dependencies on STANDARD

Line 74: -- Standard IN params

70: -- Spec Procedure Process_Ata_Sequences --
71: ------------------------------------------
72: PROCEDURE Process_Ata_Sequences
73: (
74: -- Standard IN params
75: p_api_version IN NUMBER,
76: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
77: p_commit IN VARCHAR2 := FND_API.G_FALSE,
78: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 81: -- Standard OUT params

77: p_commit IN VARCHAR2 := FND_API.G_FALSE,
78: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
79: p_default IN VARCHAR2 := FND_API.G_FALSE,
80: p_module_type IN VARCHAR2 := NULL,
81: -- Standard OUT params
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2,
85: -- Procedure IN, OUT, IN/OUT params

Line 138: -- Standard start of API savepoint

134: l_jtf_note_id NUMBER;
135: l_note_contexts_tbl JTF_NOTES_PUB.jtf_note_contexts_tbl_type;
136:
137: BEGIN
138: -- Standard start of API savepoint
139: SAVEPOINT Process_Ata_Sequences_SP;
140:
141: -- Initialize return status to success before any code logic/validation
142: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 144: -- Standard call to check for call compatibility

140:
141: -- Initialize return status to success before any code logic/validation
142: x_return_status := FND_API.G_RET_STS_SUCCESS;
143:
144: -- Standard call to check for call compatibility
145: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
146: THEN
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148: END IF;

Line 788: -- Standard call to get message count and if count is 1, get message info

784: THEN
785: COMMIT WORK;
786: END IF;
787:
788: -- Standard call to get message count and if count is 1, get message info
789: FND_MSG_PUB.count_and_get
790: (
791: p_count => x_msg_count,
792: p_data => x_msg_data,

Line 842: -- Standard IN params

838: -- Spec Procedure Process_Mo_Procedures --
839: ------------------------------------------
840: PROCEDURE Process_Mo_Procedures
841: (
842: -- Standard IN params
843: p_api_version IN NUMBER,
844: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
845: p_commit IN VARCHAR2 := FND_API.G_TRUE,
846: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 849: -- Standard OUT params

845: p_commit IN VARCHAR2 := FND_API.G_TRUE,
846: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
847: p_default IN VARCHAR2 := FND_API.G_FALSE,
848: p_module_type IN VARCHAR2 := NULL,
849: -- Standard OUT params
850: x_return_status OUT NOCOPY VARCHAR2,
851: x_msg_count OUT NOCOPY NUMBER,
852: x_msg_data OUT NOCOPY VARCHAR2,
853: -- Procedure IN, OUT, IN/OUT params

Line 917: -- Standard start of API savepoint

913: l_msg_data VARCHAR2(2000);
914: l_status VARCHAR2(30);
915:
916: BEGIN
917: -- Standard start of API savepoint
918: SAVEPOINT Process_Mo_Procedures_SP;
919:
920: -- Initialize return status to success before any code logic/validation
921: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 923: -- Standard call to check for call compatibility

919:
920: -- Initialize return status to success before any code logic/validation
921: x_return_status := FND_API.G_RET_STS_SUCCESS;
922:
923: -- Standard call to check for call compatibility
924: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
925: THEN
926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: END IF;

Line 1188: -- Standard call to get message count and if count is 1, get message info

1184: THEN
1185: COMMIT WORK;
1186: END IF;
1187:
1188: -- Standard call to get message count and if count is 1, get message info
1189: FND_MSG_PUB.count_and_get
1190: (
1191: p_count => x_msg_count,
1192: p_data => x_msg_data,

Line 1242: -- Standard IN params

1238: -- Spec Procedure Process_Ata_Relations --
1239: ------------------------------------------
1240: PROCEDURE Process_Ata_Relations
1241: (
1242: -- Standard IN params
1243: p_api_version IN NUMBER,
1244: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1245: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 1307: -- Standard start of API savepoint

1303: -- Define cursors
1304:
1305: BEGIN
1306:
1307: -- Standard start of API savepoint
1308: SAVEPOINT Process_Ata_Relations_SP;
1309:
1310: -- Initialize return status to success before any code logic/validation
1311: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1313: -- Standard call to check for call compatibility

1309:
1310: -- Initialize return status to success before any code logic/validation
1311: x_return_status := FND_API.G_RET_STS_SUCCESS;
1312:
1313: -- Standard call to check for call compatibility
1314: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1315: THEN
1316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1317: END IF;

Line 1614: -- Standard call to get message count and if count is 1, get message info

1610: THEN
1611: COMMIT WORK;
1612: END IF;
1613:
1614: -- Standard call to get message count and if count is 1, get message info
1615: FND_MSG_PUB.count_and_get
1616: (
1617: p_count => x_msg_count,
1618: p_data => x_msg_data,

Line 1668: -- Standard IN params

1664: -- Spec Procedure Process_Ata_Relations --
1665: ------------------------------------------
1666: PROCEDURE Copy_MO_Proc_Revision
1667: (
1668: -- Standard IN params
1669: p_api_version IN NUMBER,
1670: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1671: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1672: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 1675: -- Standard OUT params

1671: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1672: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1673: p_default IN VARCHAR2 := FND_API.G_FALSE,
1674: p_module_type IN VARCHAR2 := NULL,
1675: -- Standard OUT params
1676: x_return_status OUT NOCOPY VARCHAR2,
1677: x_msg_count OUT NOCOPY NUMBER,
1678: x_msg_data OUT NOCOPY VARCHAR2,
1679: -- Procedure IN, OUT, IN/OUT params

Line 1703: -- Standard start of API savepoint

1699:
1700: l_ata_seq_id number;
1701:
1702: BEGIN
1703: -- Standard start of API savepoint
1704: SAVEPOINT Copy_MO_Proc_Revision_SP;
1705:
1706: -- Initialize return status to success before any code logic/validation
1707: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1709: -- Standard call to check for call compatibility

1705:
1706: -- Initialize return status to success before any code logic/validation
1707: x_return_status := FND_API.G_RET_STS_SUCCESS;
1708:
1709: -- Standard call to check for call compatibility
1710: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1711: THEN
1712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1713: END IF;

Line 1828: -- Standard call to get message count and if count is 1, get message info

1824: THEN
1825: COMMIT WORK;
1826: END IF;
1827:
1828: -- Standard call to get message count and if count is 1, get message info
1829: FND_MSG_PUB.count_and_get
1830: (
1831: p_count => x_msg_count,
1832: p_data => x_msg_data,