DBA Data[Home] [Help]

APPS.PV_PROCESS_RULE_PVT dependencies on PV_RULE_RECTYPE_PUB

Line 36: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE

32: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
33: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
35: P_Identity_Resource_Id IN NUMBER,
36: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE
37: := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
38: X_PROCESS_RULE_ID OUT NOCOPY NUMBER,
39: X_Return_Status OUT NOCOPY VARCHAR2,
40: X_Msg_Count OUT NOCOPY NUMBER,

Line 37: := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,

33: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
35: P_Identity_Resource_Id IN NUMBER,
36: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE
37: := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
38: X_PROCESS_RULE_ID OUT NOCOPY NUMBER,
39: X_Return_Status OUT NOCOPY VARCHAR2,
40: X_Msg_Count OUT NOCOPY NUMBER,
41: X_Msg_Data OUT NOCOPY VARCHAR2

Line 301: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,

297: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
298: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
299: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
300: P_Identity_Resource_Id IN NUMBER,
301: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
302: X_Return_Status OUT NOCOPY VARCHAR2,
303: X_Msg_Count OUT NOCOPY NUMBER,
304: X_Msg_Data OUT NOCOPY VARCHAR2
305: )

Line 318: l_ref_PROCESS_RULE_rec PV_RULE_RECTYPE_PUB.RULES_REC_TYPE;

314:
315: l_api_name CONSTANT VARCHAR2(30) := 'Update_process_rule';
316: l_api_version_number CONSTANT NUMBER := 2.0;
317: -- Local Variables
318: l_ref_PROCESS_RULE_rec PV_RULE_RECTYPE_PUB.RULES_REC_TYPE;
319: l_tar_PROCESS_RULE_rec PV_RULE_RECTYPE_PUB.RULES_REC_TYPE := P_PROCESS_RULE_Rec;
320: BEGIN
321: -- Standard Start of API savepoint
322: SAVEPOINT UPDATE_PROCESS_RULE_PVT;

Line 319: l_tar_PROCESS_RULE_rec PV_RULE_RECTYPE_PUB.RULES_REC_TYPE := P_PROCESS_RULE_Rec;

315: l_api_name CONSTANT VARCHAR2(30) := 'Update_process_rule';
316: l_api_version_number CONSTANT NUMBER := 2.0;
317: -- Local Variables
318: l_ref_PROCESS_RULE_rec PV_RULE_RECTYPE_PUB.RULES_REC_TYPE;
319: l_tar_PROCESS_RULE_rec PV_RULE_RECTYPE_PUB.RULES_REC_TYPE := P_PROCESS_RULE_Rec;
320: BEGIN
321: -- Standard Start of API savepoint
322: SAVEPOINT UPDATE_PROCESS_RULE_PVT;
323:

Line 601: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,

597: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
598: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
599: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
600: P_Identity_Resource_Id IN NUMBER,
601: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
602: X_Return_Status OUT NOCOPY VARCHAR2,
603: X_Msg_Count OUT NOCOPY NUMBER,
604: X_Msg_Data OUT NOCOPY VARCHAR2
605: )

Line 680: l_ENTYROUT_rec PV_RULE_RECTYPE_PUB.ENTYROUT_Rec_Type;

676: from pv_process_rules_vl
677: where parent_rule_id = pc_rule_id;
678:
679:
680: l_ENTYROUT_rec PV_RULE_RECTYPE_PUB.ENTYROUT_Rec_Type;
681: l_ENTYATTMAP_rec PV_RULE_RECTYPE_PUB.ENTYATTMAP_Rec_Type;
682: l_SELCRIT_rec PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type;
683:
684: l_process_rule_name varchar2(100);

Line 681: l_ENTYATTMAP_rec PV_RULE_RECTYPE_PUB.ENTYATTMAP_Rec_Type;

677: where parent_rule_id = pc_rule_id;
678:
679:
680: l_ENTYROUT_rec PV_RULE_RECTYPE_PUB.ENTYROUT_Rec_Type;
681: l_ENTYATTMAP_rec PV_RULE_RECTYPE_PUB.ENTYATTMAP_Rec_Type;
682: l_SELCRIT_rec PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type;
683:
684: l_process_rule_name varchar2(100);
685: l_selection_criteria_id number;

Line 682: l_SELCRIT_rec PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type;

678:
679:
680: l_ENTYROUT_rec PV_RULE_RECTYPE_PUB.ENTYROUT_Rec_Type;
681: l_ENTYATTMAP_rec PV_RULE_RECTYPE_PUB.ENTYATTMAP_Rec_Type;
682: l_SELCRIT_rec PV_RULE_RECTYPE_PUB.SELCRIT_Rec_Type;
683:
684: l_process_rule_name varchar2(100);
685: l_selection_criteria_id number;
686: l_mapping_id number;

Line 1012: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE

1008: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1009: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1010: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1011: P_Identity_Resource_Id IN NUMBER,
1012: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE
1013: := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
1014: X_PROCESS_RULE_ID OUT NOCOPY NUMBER,
1015: X_Return_Status OUT NOCOPY VARCHAR2,
1016: X_Msg_Count OUT NOCOPY NUMBER,

Line 1013: := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,

1009: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1010: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1011: P_Identity_Resource_Id IN NUMBER,
1012: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE
1013: := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
1014: X_PROCESS_RULE_ID OUT NOCOPY NUMBER,
1015: X_Return_Status OUT NOCOPY VARCHAR2,
1016: X_Msg_Count OUT NOCOPY NUMBER,
1017: X_Msg_Data OUT NOCOPY VARCHAR2

Line 1074: --l_PROCESS_RULE_rec PV_RULE_RECTYPE_PUB.RULES_REC_TYPE;

1070: ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15
1071: From PV_ENTITY_ROUTINGS
1072: Where process_rule_id = pc_PROCESS_RULE_ID;
1073:
1074: --l_PROCESS_RULE_rec PV_RULE_RECTYPE_PUB.RULES_REC_TYPE;
1075: --l_ENTY_SELECT_CRITERIA_rec PV_RULE_RECTYPE_PUB.SELCRIT_REC_TYPE;
1076: --l_SELECT_ATTR_VALUES_rec PV_RULE_RECTYPE_PUB.SELATTVAL_REC_TYPE;
1077: --l_ENTITY_ATTR_MAPPINGS_rec PV_RULE_RECTYPE_PUB.ENTYATTMAP_REC_TYPE;
1078: --l_ENTITY_ROUTINGS_rec PV_RULE_RECTYPE_PUB.ENTYROUT_REC_TYPE;

Line 1075: --l_ENTY_SELECT_CRITERIA_rec PV_RULE_RECTYPE_PUB.SELCRIT_REC_TYPE;

1071: From PV_ENTITY_ROUTINGS
1072: Where process_rule_id = pc_PROCESS_RULE_ID;
1073:
1074: --l_PROCESS_RULE_rec PV_RULE_RECTYPE_PUB.RULES_REC_TYPE;
1075: --l_ENTY_SELECT_CRITERIA_rec PV_RULE_RECTYPE_PUB.SELCRIT_REC_TYPE;
1076: --l_SELECT_ATTR_VALUES_rec PV_RULE_RECTYPE_PUB.SELATTVAL_REC_TYPE;
1077: --l_ENTITY_ATTR_MAPPINGS_rec PV_RULE_RECTYPE_PUB.ENTYATTMAP_REC_TYPE;
1078: --l_ENTITY_ROUTINGS_rec PV_RULE_RECTYPE_PUB.ENTYROUT_REC_TYPE;
1079: --l_api_version_number CONSTANT NUMBER := 2.0;

Line 1076: --l_SELECT_ATTR_VALUES_rec PV_RULE_RECTYPE_PUB.SELATTVAL_REC_TYPE;

1072: Where process_rule_id = pc_PROCESS_RULE_ID;
1073:
1074: --l_PROCESS_RULE_rec PV_RULE_RECTYPE_PUB.RULES_REC_TYPE;
1075: --l_ENTY_SELECT_CRITERIA_rec PV_RULE_RECTYPE_PUB.SELCRIT_REC_TYPE;
1076: --l_SELECT_ATTR_VALUES_rec PV_RULE_RECTYPE_PUB.SELATTVAL_REC_TYPE;
1077: --l_ENTITY_ATTR_MAPPINGS_rec PV_RULE_RECTYPE_PUB.ENTYATTMAP_REC_TYPE;
1078: --l_ENTITY_ROUTINGS_rec PV_RULE_RECTYPE_PUB.ENTYROUT_REC_TYPE;
1079: --l_api_version_number CONSTANT NUMBER := 2.0;
1080: --l_Init_Msg_List VARCHAR2(30) := FND_API.G_FALSE;

Line 1077: --l_ENTITY_ATTR_MAPPINGS_rec PV_RULE_RECTYPE_PUB.ENTYATTMAP_REC_TYPE;

1073:
1074: --l_PROCESS_RULE_rec PV_RULE_RECTYPE_PUB.RULES_REC_TYPE;
1075: --l_ENTY_SELECT_CRITERIA_rec PV_RULE_RECTYPE_PUB.SELCRIT_REC_TYPE;
1076: --l_SELECT_ATTR_VALUES_rec PV_RULE_RECTYPE_PUB.SELATTVAL_REC_TYPE;
1077: --l_ENTITY_ATTR_MAPPINGS_rec PV_RULE_RECTYPE_PUB.ENTYATTMAP_REC_TYPE;
1078: --l_ENTITY_ROUTINGS_rec PV_RULE_RECTYPE_PUB.ENTYROUT_REC_TYPE;
1079: --l_api_version_number CONSTANT NUMBER := 2.0;
1080: --l_Init_Msg_List VARCHAR2(30) := FND_API.G_FALSE;
1081: --l_Commit VARCHAR2(30) := FND_API.G_FALSE;

Line 1078: --l_ENTITY_ROUTINGS_rec PV_RULE_RECTYPE_PUB.ENTYROUT_REC_TYPE;

1074: --l_PROCESS_RULE_rec PV_RULE_RECTYPE_PUB.RULES_REC_TYPE;
1075: --l_ENTY_SELECT_CRITERIA_rec PV_RULE_RECTYPE_PUB.SELCRIT_REC_TYPE;
1076: --l_SELECT_ATTR_VALUES_rec PV_RULE_RECTYPE_PUB.SELATTVAL_REC_TYPE;
1077: --l_ENTITY_ATTR_MAPPINGS_rec PV_RULE_RECTYPE_PUB.ENTYATTMAP_REC_TYPE;
1078: --l_ENTITY_ROUTINGS_rec PV_RULE_RECTYPE_PUB.ENTYROUT_REC_TYPE;
1079: --l_api_version_number CONSTANT NUMBER := 2.0;
1080: --l_Init_Msg_List VARCHAR2(30) := FND_API.G_FALSE;
1081: --l_Commit VARCHAR2(30) := FND_API.G_FALSE;
1082: --l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

Line 1832: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,

1828: PROCEDURE Validate_process_rule(
1829: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1830: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1831: P_Validation_mode IN VARCHAR2,
1832: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
1833: X_Return_Status OUT NOCOPY VARCHAR2,
1834: X_Msg_Count OUT NOCOPY NUMBER,
1835: X_Msg_Data OUT NOCOPY VARCHAR2
1836: )