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 794: -- Standard call to get message count and if count is 1, get message info

790: THEN
791: COMMIT WORK;
792: END IF;
793:
794: -- Standard call to get message count and if count is 1, get message info
795: FND_MSG_PUB.count_and_get
796: (
797: p_count => x_msg_count,
798: p_data => x_msg_data,

Line 848: -- Standard IN params

844: -- Spec Procedure Process_Mo_Procedures --
845: ------------------------------------------
846: PROCEDURE Process_Mo_Procedures
847: (
848: -- Standard IN params
849: p_api_version IN NUMBER,
850: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
851: p_commit IN VARCHAR2 := FND_API.G_TRUE,
852: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 855: -- Standard OUT params

851: p_commit IN VARCHAR2 := FND_API.G_TRUE,
852: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
853: p_default IN VARCHAR2 := FND_API.G_FALSE,
854: p_module_type IN VARCHAR2 := NULL,
855: -- Standard OUT params
856: x_return_status OUT NOCOPY VARCHAR2,
857: x_msg_count OUT NOCOPY NUMBER,
858: x_msg_data OUT NOCOPY VARCHAR2,
859: -- Procedure IN, OUT, IN/OUT params

Line 923: -- Standard start of API savepoint

919: l_msg_data VARCHAR2(2000);
920: l_status VARCHAR2(30);
921:
922: BEGIN
923: -- Standard start of API savepoint
924: SAVEPOINT Process_Mo_Procedures_SP;
925:
926: -- Initialize return status to success before any code logic/validation
927: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

925:
926: -- Initialize return status to success before any code logic/validation
927: x_return_status := FND_API.G_RET_STS_SUCCESS;
928:
929: -- Standard call to check for call compatibility
930: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
931: THEN
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: END IF;

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

1190: THEN
1191: COMMIT WORK;
1192: END IF;
1193:
1194: -- Standard call to get message count and if count is 1, get message info
1195: FND_MSG_PUB.count_and_get
1196: (
1197: p_count => x_msg_count,
1198: p_data => x_msg_data,

Line 1248: -- Standard IN params

1244: -- Spec Procedure Process_Ata_Relations --
1245: ------------------------------------------
1246: PROCEDURE Process_Ata_Relations
1247: (
1248: -- Standard IN params
1249: p_api_version IN NUMBER,
1250: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1251: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 1313: -- Standard start of API savepoint

1309: -- Define cursors
1310:
1311: BEGIN
1312:
1313: -- Standard start of API savepoint
1314: SAVEPOINT Process_Ata_Relations_SP;
1315:
1316: -- Initialize return status to success before any code logic/validation
1317: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1315:
1316: -- Initialize return status to success before any code logic/validation
1317: x_return_status := FND_API.G_RET_STS_SUCCESS;
1318:
1319: -- Standard call to check for call compatibility
1320: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1321: THEN
1322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1323: END IF;

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

1616: THEN
1617: COMMIT WORK;
1618: END IF;
1619:
1620: -- Standard call to get message count and if count is 1, get message info
1621: FND_MSG_PUB.count_and_get
1622: (
1623: p_count => x_msg_count,
1624: p_data => x_msg_data,

Line 1674: -- Standard IN params

1670: -- Spec Procedure Process_Ata_Relations --
1671: ------------------------------------------
1672: PROCEDURE Copy_MO_Proc_Revision
1673: (
1674: -- Standard IN params
1675: p_api_version IN NUMBER,
1676: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1677: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1678: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 1681: -- Standard OUT params

1677: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1678: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1679: p_default IN VARCHAR2 := FND_API.G_FALSE,
1680: p_module_type IN VARCHAR2 := NULL,
1681: -- Standard OUT params
1682: x_return_status OUT NOCOPY VARCHAR2,
1683: x_msg_count OUT NOCOPY NUMBER,
1684: x_msg_data OUT NOCOPY VARCHAR2,
1685: -- Procedure IN, OUT, IN/OUT params

Line 1709: -- Standard start of API savepoint

1705:
1706: l_ata_seq_id number;
1707:
1708: BEGIN
1709: -- Standard start of API savepoint
1710: SAVEPOINT Copy_MO_Proc_Revision_SP;
1711:
1712: -- Initialize return status to success before any code logic/validation
1713: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1711:
1712: -- Initialize return status to success before any code logic/validation
1713: x_return_status := FND_API.G_RET_STS_SUCCESS;
1714:
1715: -- Standard call to check for call compatibility
1716: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1717: THEN
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1719: END IF;

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

1830: THEN
1831: COMMIT WORK;
1832: END IF;
1833:
1834: -- Standard call to get message count and if count is 1, get message info
1835: FND_MSG_PUB.count_and_get
1836: (
1837: p_count => x_msg_count,
1838: p_data => x_msg_data,