251: /* */
252: /*--------------------------------------------------------------------*/
253: PROCEDURE PROCESS_RULE_MATCHING(
254: p_api_version_number IN NUMBER,
255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256: p_commit IN VARCHAR2 := FND_API.G_FALSE,
257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258: px_rule_matching_rec IN OUT NOCOPY CSD_RULE_MATCHING_REC_TYPE,
259: x_return_status OUT NOCOPY VARCHAR2,
252: /*--------------------------------------------------------------------*/
253: PROCEDURE PROCESS_RULE_MATCHING(
254: p_api_version_number IN NUMBER,
255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256: p_commit IN VARCHAR2 := FND_API.G_FALSE,
257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258: px_rule_matching_rec IN OUT NOCOPY CSD_RULE_MATCHING_REC_TYPE,
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,
253: PROCEDURE PROCESS_RULE_MATCHING(
254: p_api_version_number IN NUMBER,
255: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256: p_commit IN VARCHAR2 := FND_API.G_FALSE,
257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258: px_rule_matching_rec IN OUT NOCOPY CSD_RULE_MATCHING_REC_TYPE,
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,
261: x_msg_data OUT NOCOPY VARCHAR2
283: /* if null, then no rule used */
284: /*--------------------------------------------------------------------*/
285: PROCEDURE SOO_DEFAULTING (
286: p_api_version_number IN NUMBER,
287: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
288: p_commit IN VARCHAR2 := FND_API.G_FALSE,
289: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
290: p_event_type IN VARCHAR2,
291: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,
284: /*--------------------------------------------------------------------*/
285: PROCEDURE SOO_DEFAULTING (
286: p_api_version_number IN NUMBER,
287: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
288: p_commit IN VARCHAR2 := FND_API.G_FALSE,
289: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
290: p_event_type IN VARCHAR2,
291: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,
292: x_rule_id OUT NOCOPY NUMBER,
285: PROCEDURE SOO_DEFAULTING (
286: p_api_version_number IN NUMBER,
287: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
288: p_commit IN VARCHAR2 := FND_API.G_FALSE,
289: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
290: p_event_type IN VARCHAR2,
291: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,
292: x_rule_id OUT NOCOPY NUMBER,
293: x_return_status OUT NOCOPY VARCHAR2,
297:
298: -- PROCEDURE to update the RO status and/or execute the PL/SQL action.
299: PROCEDURE PROCESS_SOO_RULE(
300: p_api_version_number IN NUMBER,
301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
302: p_commit IN VARCHAR2 := FND_API.G_FALSE,
303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
304: p_ro_flow_status_id IN NUMBER,
305: p_flow_status_reason_code IN VARCHAR2,
298: -- PROCEDURE to update the RO status and/or execute the PL/SQL action.
299: PROCEDURE PROCESS_SOO_RULE(
300: p_api_version_number IN NUMBER,
301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
302: p_commit IN VARCHAR2 := FND_API.G_FALSE,
303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
304: p_ro_flow_status_id IN NUMBER,
305: p_flow_status_reason_code IN VARCHAR2,
306: p_action IN VARCHAR2,
299: PROCEDURE PROCESS_SOO_RULE(
300: p_api_version_number IN NUMBER,
301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
302: p_commit IN VARCHAR2 := FND_API.G_FALSE,
303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
304: p_ro_flow_status_id IN NUMBER,
305: p_flow_status_reason_code IN VARCHAR2,
306: p_action IN VARCHAR2,
307: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,
338: /* */
339: /*--------------------------------------------------------------------*/
340: PROCEDURE GET_DEFAULT_VALUE_FROM_RULE (
341: p_api_version_number IN NUMBER,
342: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
343: p_commit IN VARCHAR2 := FND_API.G_FALSE,
344: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
345: p_entity_attribute_type IN VARCHAR2,
346: p_entity_attribute_code IN VARCHAR2,
339: /*--------------------------------------------------------------------*/
340: PROCEDURE GET_DEFAULT_VALUE_FROM_RULE (
341: p_api_version_number IN NUMBER,
342: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
343: p_commit IN VARCHAR2 := FND_API.G_FALSE,
344: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
345: p_entity_attribute_type IN VARCHAR2,
346: p_entity_attribute_code IN VARCHAR2,
347: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,
340: PROCEDURE GET_DEFAULT_VALUE_FROM_RULE (
341: p_api_version_number IN NUMBER,
342: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
343: p_commit IN VARCHAR2 := FND_API.G_FALSE,
344: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
345: p_entity_attribute_type IN VARCHAR2,
346: p_entity_attribute_code IN VARCHAR2,
347: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,
348: x_default_value OUT NOCOPY VARCHAR2,
380: /* */
381: /*--------------------------------------------------------------------*/
382: PROCEDURE GET_DEFAULT_VALUE_FROM_RULE (
383: p_api_version_number IN NUMBER,
384: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
385: p_commit IN VARCHAR2 := FND_API.G_FALSE,
386: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
387: p_entity_attribute_type IN VARCHAR2,
388: p_entity_attribute_code IN VARCHAR2,
381: /*--------------------------------------------------------------------*/
382: PROCEDURE GET_DEFAULT_VALUE_FROM_RULE (
383: p_api_version_number IN NUMBER,
384: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
385: p_commit IN VARCHAR2 := FND_API.G_FALSE,
386: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
387: p_entity_attribute_type IN VARCHAR2,
388: p_entity_attribute_code IN VARCHAR2,
389: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,
382: PROCEDURE GET_DEFAULT_VALUE_FROM_RULE (
383: p_api_version_number IN NUMBER,
384: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
385: p_commit IN VARCHAR2 := FND_API.G_FALSE,
386: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
387: p_entity_attribute_type IN VARCHAR2,
388: p_entity_attribute_code IN VARCHAR2,
389: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,
390: x_default_value OUT NOCOPY NUMBER,
422: /* */
423: /*--------------------------------------------------------------------*/
424: PROCEDURE GET_DEFAULT_VALUE_FROM_RULE (
425: p_api_version_number IN NUMBER,
426: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
427: p_commit IN VARCHAR2 := FND_API.G_FALSE,
428: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
429: p_entity_attribute_type IN VARCHAR2,
430: p_entity_attribute_code IN VARCHAR2,
423: /*--------------------------------------------------------------------*/
424: PROCEDURE GET_DEFAULT_VALUE_FROM_RULE (
425: p_api_version_number IN NUMBER,
426: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
427: p_commit IN VARCHAR2 := FND_API.G_FALSE,
428: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
429: p_entity_attribute_type IN VARCHAR2,
430: p_entity_attribute_code IN VARCHAR2,
431: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,
424: PROCEDURE GET_DEFAULT_VALUE_FROM_RULE (
425: p_api_version_number IN NUMBER,
426: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
427: p_commit IN VARCHAR2 := FND_API.G_FALSE,
428: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
429: p_entity_attribute_type IN VARCHAR2,
430: p_entity_attribute_code IN VARCHAR2,
431: p_rule_input_rec IN CSD_RULE_INPUT_REC_TYPE,
432: x_default_value OUT NOCOPY DATE,