DBA Data[Home] [Help]

APPS.PA_ADVERTISEMENTS_PUB dependencies on PA_ACTION_SET_UTILS

Line 7: g_action_line_audit_tbl pa_action_set_utils.insert_audit_lines_tbl_type;

3: --
4:
5: -- global variable to store the audit lines to be returned
6: -- to the generic action set api when an action line is performed
7: g_action_line_audit_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
8:
9: -- global variable to store the start advertisement action set flag
10: g_start_adv_action_set_flag VARCHAR2(1) := NULL;
11:

Line 24: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type

20: ----------------------------------------------------------------------
21: PROCEDURE Validate_Action_Set_Line (
22: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
23: , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
24: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
25: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
26: );
27:
28:

Line 60: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type

56: PROCEDURE Perform_Action_Set_Line (
57: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
58: , p_action_set_details_rec IN pa_action_sets%ROWTYPE
59: , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
60: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
61: , x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type -- For 1159 mandate changes bug#2674619
62: , x_action_line_result_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
63: );
64:

Line 61: , x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type -- For 1159 mandate changes bug#2674619

57: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
58: , p_action_set_details_rec IN pa_action_sets%ROWTYPE
59: , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
60: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
61: , x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type -- For 1159 mandate changes bug#2674619
62: , x_action_line_result_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
63: );
64:
65: