DBA Data[Home] [Help]

APPS.AMW_AUDIT_PROCEDURES_PVT dependencies on FND_API

Line 21: -- FND_API global constant

17: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_ID;
18: G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
19: G_OBJ_TYPE CONSTANT VARCHAR2(80) := AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_OBJECT_TYPE','AP');
20:
21: -- FND_API global constant
22: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
23: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
24: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 22: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

18: G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
19: G_OBJ_TYPE CONSTANT VARCHAR2(80) := AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_OBJECT_TYPE','AP');
20:
21: -- FND_API global constant
22: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
23: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
24: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 23: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

19: G_OBJ_TYPE CONSTANT VARCHAR2(80) := AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_OBJECT_TYPE','AP');
20:
21: -- FND_API global constant
22: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
23: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
24: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 24: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;

20:
21: -- FND_API global constant
22: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
23: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
24: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
28:

Line 25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

21: -- FND_API global constant
22: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
23: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
24: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
28:
29:

Line 26: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

22: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
23: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
24: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
28:
29:
30: -- Operate_AP with global p_operate_mode

Line 27: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

23: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
24: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
28:
29:
30: -- Operate_AP with global p_operate_mode
31: G_OP_CREATE CONSTANT NUMBER := 10;

Line 356: -- FND_API.G_MISS_XXX v.s. NULL has been changed to:

352: -- check the requireness of the items which have been marked
353: -- as NOT NULL in table
354: -- Note
355: -- since the standard default with
356: -- FND_API.G_MISS_XXX v.s. NULL has been changed to:
357: -- if user want to update to Null, pass in G_MISS_XXX
358: -- else if user want to update to some value, pass in value
359: -- else if user doesn't want to update, pass in NULL.
360: -- Reference

Line 524: p_init_msg_list IN VARCHAR2, -- default FND_API.G_FALSE,

520: --
521: -- ===============================================================
522: PROCEDURE copy_audit_steps(
523: p_api_version IN NUMBER,
524: p_init_msg_list IN VARCHAR2, -- default FND_API.G_FALSE,
525: p_commit IN VARCHAR2, -- default FND_API.G_FALSE,
526: p_validation_level IN NUMBER, -- default FND_API.G_VALID_LEVEL_FULL,
527: x_return_status OUT NOCOPY VARCHAR2,
528: x_msg_count OUT NOCOPY NUMBER,

Line 525: p_commit IN VARCHAR2, -- default FND_API.G_FALSE,

521: -- ===============================================================
522: PROCEDURE copy_audit_steps(
523: p_api_version IN NUMBER,
524: p_init_msg_list IN VARCHAR2, -- default FND_API.G_FALSE,
525: p_commit IN VARCHAR2, -- default FND_API.G_FALSE,
526: p_validation_level IN NUMBER, -- default FND_API.G_VALID_LEVEL_FULL,
527: x_return_status OUT NOCOPY VARCHAR2,
528: x_msg_count OUT NOCOPY NUMBER,
529: x_msg_data OUT NOCOPY VARCHAR2,

Line 526: p_validation_level IN NUMBER, -- default FND_API.G_VALID_LEVEL_FULL,

522: PROCEDURE copy_audit_steps(
523: p_api_version IN NUMBER,
524: p_init_msg_list IN VARCHAR2, -- default FND_API.G_FALSE,
525: p_commit IN VARCHAR2, -- default FND_API.G_FALSE,
526: p_validation_level IN NUMBER, -- default FND_API.G_VALID_LEVEL_FULL,
527: x_return_status OUT NOCOPY VARCHAR2,
528: x_msg_count OUT NOCOPY NUMBER,
529: x_msg_data OUT NOCOPY VARCHAR2,
530: x_from_ap_rev_id IN NUMBER,

Line 545: p_init_msg_list IN VARCHAR2, -- default FND_API.G_FALSE,

541: --
542: -- ===============================================================
543: PROCEDURE copy_tasks(
544: p_api_version IN NUMBER,
545: p_init_msg_list IN VARCHAR2, -- default FND_API.G_FALSE,
546: p_commit IN VARCHAR2, -- default FND_API.G_FALSE,
547: p_validation_level IN NUMBER, -- default FND_API.G_VALID_LEVEL_FULL,
548: x_return_status OUT NOCOPY VARCHAR2,
549: x_msg_count OUT NOCOPY NUMBER,

Line 546: p_commit IN VARCHAR2, -- default FND_API.G_FALSE,

542: -- ===============================================================
543: PROCEDURE copy_tasks(
544: p_api_version IN NUMBER,
545: p_init_msg_list IN VARCHAR2, -- default FND_API.G_FALSE,
546: p_commit IN VARCHAR2, -- default FND_API.G_FALSE,
547: p_validation_level IN NUMBER, -- default FND_API.G_VALID_LEVEL_FULL,
548: x_return_status OUT NOCOPY VARCHAR2,
549: x_msg_count OUT NOCOPY NUMBER,
550: x_msg_data OUT NOCOPY VARCHAR2,

Line 547: p_validation_level IN NUMBER, -- default FND_API.G_VALID_LEVEL_FULL,

543: PROCEDURE copy_tasks(
544: p_api_version IN NUMBER,
545: p_init_msg_list IN VARCHAR2, -- default FND_API.G_FALSE,
546: p_commit IN VARCHAR2, -- default FND_API.G_FALSE,
547: p_validation_level IN NUMBER, -- default FND_API.G_VALID_LEVEL_FULL,
548: x_return_status OUT NOCOPY VARCHAR2,
549: x_msg_count OUT NOCOPY NUMBER,
550: x_msg_data OUT NOCOPY VARCHAR2,
551: x_from_ap_id IN NUMBER,

Line 566: p_init_msg_list IN VARCHAR2, -- default FND_API.G_FALSE,

562: --
563: -- ===============================================================
564: PROCEDURE copy_controls(
565: p_api_version IN NUMBER,
566: p_init_msg_list IN VARCHAR2, -- default FND_API.G_FALSE,
567: p_commit IN VARCHAR2, -- default FND_API.G_FALSE,
568: p_validation_level IN NUMBER, -- default FND_API.G_VALID_LEVEL_FULL,
569: x_return_status OUT NOCOPY VARCHAR2,
570: x_msg_count OUT NOCOPY NUMBER,

Line 567: p_commit IN VARCHAR2, -- default FND_API.G_FALSE,

563: -- ===============================================================
564: PROCEDURE copy_controls(
565: p_api_version IN NUMBER,
566: p_init_msg_list IN VARCHAR2, -- default FND_API.G_FALSE,
567: p_commit IN VARCHAR2, -- default FND_API.G_FALSE,
568: p_validation_level IN NUMBER, -- default FND_API.G_VALID_LEVEL_FULL,
569: x_return_status OUT NOCOPY VARCHAR2,
570: x_msg_count OUT NOCOPY NUMBER,
571: x_msg_data OUT NOCOPY VARCHAR2,

Line 568: p_validation_level IN NUMBER, -- default FND_API.G_VALID_LEVEL_FULL,

564: PROCEDURE copy_controls(
565: p_api_version IN NUMBER,
566: p_init_msg_list IN VARCHAR2, -- default FND_API.G_FALSE,
567: p_commit IN VARCHAR2, -- default FND_API.G_FALSE,
568: p_validation_level IN NUMBER, -- default FND_API.G_VALID_LEVEL_FULL,
569: x_return_status OUT NOCOPY VARCHAR2,
570: x_msg_count OUT NOCOPY NUMBER,
571: x_msg_data OUT NOCOPY VARCHAR2,
572: x_from_ap_id IN NUMBER,