eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ACTION_SETS_PVT dependencies on PA_ACTION_SET_UTILS

Line 61: l_unique := PA_ACTION_SET_UTILS.is_name_unique_in_type(

57: END IF;
58:
59: IF p_action_set_template_flag = 'Y' THEN
60:
61: l_unique := PA_ACTION_SET_UTILS.is_name_unique_in_type(
62: p_action_set_type_code => p_action_set_type_code,
63: p_action_set_name => p_action_set_name);
64:
65: IF l_unique = 'N' THEN

Line 79: l_existing_action_set_id := PA_ACTION_SET_UTILS.get_action_set_id(

75: END IF;
76:
77: ELSE
78:
79: l_existing_action_set_id := PA_ACTION_SET_UTILS.get_action_set_id(
80: p_action_set_type_code => p_action_set_type_code,
81: p_object_type => p_object_type,
82: p_object_id => p_object_id);
83:

Line 256: l_unique := PA_ACTION_SET_UTILS.is_name_unique_in_type(

252: IF l_action_set_template_flag = 'Y' THEN
253:
254: IF p_action_set_name IS NOT NULL THEN
255:
256: l_unique := PA_ACTION_SET_UTILS.is_name_unique_in_type(
257: p_action_set_type_code => l_action_set_type_code,
258: p_action_set_name => p_action_set_name,
259: p_action_set_id => p_action_set_id);
260:

Line 376: l_action_set_lines_tbl pa_action_set_utils.action_set_lines_tbl_type;

372: l_action_set_id NUMBER;
373: l_record_version_number NUMBER;
374: l_is_source VARCHAR2(1);
375: l_do_lines_exist VARCHAR2(1);
376: l_action_set_lines_tbl pa_action_set_utils.action_set_lines_tbl_type;
377: l_action_set_template_flag VARCHAR2(1);
378: l_debug_mode VARCHAR2(20) := 'N';
379:
380: BEGIN

Line 402: l_is_source := PA_ACTION_SET_UTILS.is_action_set_a_source(p_action_set_id => p_action_set_id);

398: WHERE action_set_id = p_action_set_id;
399:
400: IF l_action_set_template_flag = 'Y' THEN
401:
402: l_is_source := PA_ACTION_SET_UTILS.is_action_set_a_source(p_action_set_id => p_action_set_id);
403:
404: IF l_is_source = 'Y' THEN
405: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
406: ,p_msg_name => 'PA_ACTION_SET_IS_SOURCE');

Line 413: l_action_set_lines_tbl := pa_action_set_utils.get_action_set_lines(p_action_set_id => p_action_set_id);

409: END IF;
410:
411: IF FND_MSG_PUB.Count_Msg = 0 THEN
412:
413: l_action_set_lines_tbl := pa_action_set_utils.get_action_set_lines(p_action_set_id => p_action_set_id);
414:
415: IF l_action_set_lines_tbl.COUNT > 0 THEN
416:
417: FOR i IN l_action_set_lines_tbl.FIRST .. l_action_set_lines_tbl.LAST LOOP

Line 431: l_do_lines_exist := PA_ACTION_SET_UTILS.do_lines_exist(p_action_set_id => p_action_set_id);

427: END IF;
428:
429: IF FND_MSG_PUB.Count_Msg = 0 THEN
430:
431: l_do_lines_exist := PA_ACTION_SET_UTILS.do_lines_exist(p_action_set_id => p_action_set_id);
432:
433: IF l_do_lines_exist = 'N' THEN
434:
435: PA_ACTION_SETS_PKG.delete_row

Line 497: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type

493: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
494: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
495: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
496: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
497: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
498: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
499: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
500: )
501: IS

Line 653: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type := pa_action_set_utils.l_empty_condition_tbl

649: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
650: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
651: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
652: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
653: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type := pa_action_set_utils.l_empty_condition_tbl
654: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
655: )
656: IS
657:

Line 798: l_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type;

794: l_action_set_id pa_action_sets.action_set_id%TYPE;
795: l_action_set_template_flag pa_action_sets.action_set_template_flag%TYPE;
796: l_current_line_status pa_action_set_lines.status_code%TYPE;
797: l_do_audit_lines_exist VARCHAR2(1);
798: l_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type;
799: l_debug_mode VARCHAR2(20) := 'N';
800:
801: BEGIN
802:

Line 849: l_do_audit_lines_exist := PA_ACTION_SET_UTILS.do_audit_lines_exist(p_action_set_line_id => p_action_set_line_id);

845: x_return_status => l_return_status);
846:
847: ELSE
848:
849: l_do_audit_lines_exist := PA_ACTION_SET_UTILS.do_audit_lines_exist(p_action_set_line_id => p_action_set_line_id);
850: -- Bug Ref : 6797508
851: IF ( l_action_set_type_code = 'ADVERTISEMENT' ) THEN
852: IF ( l_do_audit_lines_exist = 'Y' )THEN
853: DELETE

Line 859: PA_ACTION_SET_UTILS.do_audit_lines_exist(p_action_set_line_id => p_action_set_line_id);

855: WHERE ACTION_SET_LINE_ID = P_ACTION_SET_LINE_ID;
856: END IF;
857: -- 2411522 : Need to set MOD_SOURCE_ACTION_SET_FLAG = 'Y' when deleting a line.
858: l_do_audit_lines_exist :=
859: PA_ACTION_SET_UTILS.do_audit_lines_exist(p_action_set_line_id => p_action_set_line_id);
860: IF ( l_do_audit_lines_exist = 'N' AND l_current_line_status <> 'ACTIVE' ) THEN
861: IF l_action_set_template_flag = 'N' THEN
862: UPDATE pa_action_sets
863: SET MOD_SOURCE_ACTION_SET_FLAG = 'Y'

Line 867: PA_ACTION_SET_UTILS.get_action_line_conditions(p_action_set_line_id => p_action_set_line_id);

863: SET MOD_SOURCE_ACTION_SET_FLAG = 'Y'
864: WHERE action_set_id = l_action_set_id;
865: END IF;
866: l_action_line_conditions_tbl :=
867: PA_ACTION_SET_UTILS.get_action_line_conditions(p_action_set_line_id => p_action_set_line_id);
868: FOR i IN l_action_line_conditions_tbl.FIRST .. l_action_line_conditions_tbl.LAST LOOP
869: PA_ACTION_SET_LINE_COND_PKG.delete_row
870: (p_action_set_line_condition_id => l_action_line_conditions_tbl(i).action_set_line_condition_id,
871: p_record_version_number => p_record_version_number,

Line 894: PA_ACTION_SET_UTILS.get_action_line_conditions(p_action_set_line_id => p_action_set_line_id);

890: SET MOD_SOURCE_ACTION_SET_FLAG = 'Y'
891: WHERE action_set_id = l_action_set_id;
892: END IF;
893: l_action_line_conditions_tbl :=
894: PA_ACTION_SET_UTILS.get_action_line_conditions(p_action_set_line_id => p_action_set_line_id);
895: FOR i IN l_action_line_conditions_tbl.FIRST .. l_action_line_conditions_tbl.LAST LOOP
896:
897: PA_ACTION_SET_LINE_COND_PKG.delete_row
898: (p_action_set_line_condition_id => l_action_line_conditions_tbl(i).action_set_line_condition_id,

Line 940: p_reason IN VARCHAR2) RETURN pa_action_set_utils.insert_audit_lines_tbl_type

936: END Delete_Action_Set_Line;
937:
938:
939: FUNCTION get_def_reverse_audit_lines(p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE,
940: p_reason IN VARCHAR2) RETURN pa_action_set_utils.insert_audit_lines_tbl_type
941: IS
942:
943: l_action_set_details_rec pa_action_sets%ROWTYPE;
944:

Line 945: l_active_audit_lines_tbl pa_action_set_utils.audit_lines_tbl_type;

941: IS
942:
943: l_action_set_details_rec pa_action_sets%ROWTYPE;
944:
945: l_active_audit_lines_tbl pa_action_set_utils.audit_lines_tbl_type;
946: l_insert_audit_lines_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
947: l_reason_code_tbl pa_action_set_utils.varchar_tbl_type;
948: l_action_code_tbl pa_action_set_utils.varchar_tbl_type;
949: l_audit_display_attribute_tbl pa_action_set_utils.varchar_tbl_type;

Line 946: l_insert_audit_lines_tbl pa_action_set_utils.insert_audit_lines_tbl_type;

942:
943: l_action_set_details_rec pa_action_sets%ROWTYPE;
944:
945: l_active_audit_lines_tbl pa_action_set_utils.audit_lines_tbl_type;
946: l_insert_audit_lines_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
947: l_reason_code_tbl pa_action_set_utils.varchar_tbl_type;
948: l_action_code_tbl pa_action_set_utils.varchar_tbl_type;
949: l_audit_display_attribute_tbl pa_action_set_utils.varchar_tbl_type;
950: l_audit_attribute_tbl pa_action_set_utils.varchar_tbl_type;

Line 947: l_reason_code_tbl pa_action_set_utils.varchar_tbl_type;

943: l_action_set_details_rec pa_action_sets%ROWTYPE;
944:
945: l_active_audit_lines_tbl pa_action_set_utils.audit_lines_tbl_type;
946: l_insert_audit_lines_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
947: l_reason_code_tbl pa_action_set_utils.varchar_tbl_type;
948: l_action_code_tbl pa_action_set_utils.varchar_tbl_type;
949: l_audit_display_attribute_tbl pa_action_set_utils.varchar_tbl_type;
950: l_audit_attribute_tbl pa_action_set_utils.varchar_tbl_type;
951: l_action_date_tbl pa_action_set_utils.date_tbl_type;

Line 948: l_action_code_tbl pa_action_set_utils.varchar_tbl_type;

944:
945: l_active_audit_lines_tbl pa_action_set_utils.audit_lines_tbl_type;
946: l_insert_audit_lines_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
947: l_reason_code_tbl pa_action_set_utils.varchar_tbl_type;
948: l_action_code_tbl pa_action_set_utils.varchar_tbl_type;
949: l_audit_display_attribute_tbl pa_action_set_utils.varchar_tbl_type;
950: l_audit_attribute_tbl pa_action_set_utils.varchar_tbl_type;
951: l_action_date_tbl pa_action_set_utils.date_tbl_type;
952: l_active_flag_tbl pa_action_set_utils.varchar_tbl_type;

Line 949: l_audit_display_attribute_tbl pa_action_set_utils.varchar_tbl_type;

945: l_active_audit_lines_tbl pa_action_set_utils.audit_lines_tbl_type;
946: l_insert_audit_lines_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
947: l_reason_code_tbl pa_action_set_utils.varchar_tbl_type;
948: l_action_code_tbl pa_action_set_utils.varchar_tbl_type;
949: l_audit_display_attribute_tbl pa_action_set_utils.varchar_tbl_type;
950: l_audit_attribute_tbl pa_action_set_utils.varchar_tbl_type;
951: l_action_date_tbl pa_action_set_utils.date_tbl_type;
952: l_active_flag_tbl pa_action_set_utils.varchar_tbl_type;
953: l_rev_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;

Line 950: l_audit_attribute_tbl pa_action_set_utils.varchar_tbl_type;

946: l_insert_audit_lines_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
947: l_reason_code_tbl pa_action_set_utils.varchar_tbl_type;
948: l_action_code_tbl pa_action_set_utils.varchar_tbl_type;
949: l_audit_display_attribute_tbl pa_action_set_utils.varchar_tbl_type;
950: l_audit_attribute_tbl pa_action_set_utils.varchar_tbl_type;
951: l_action_date_tbl pa_action_set_utils.date_tbl_type;
952: l_active_flag_tbl pa_action_set_utils.varchar_tbl_type;
953: l_rev_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;
954:

Line 951: l_action_date_tbl pa_action_set_utils.date_tbl_type;

947: l_reason_code_tbl pa_action_set_utils.varchar_tbl_type;
948: l_action_code_tbl pa_action_set_utils.varchar_tbl_type;
949: l_audit_display_attribute_tbl pa_action_set_utils.varchar_tbl_type;
950: l_audit_attribute_tbl pa_action_set_utils.varchar_tbl_type;
951: l_action_date_tbl pa_action_set_utils.date_tbl_type;
952: l_active_flag_tbl pa_action_set_utils.varchar_tbl_type;
953: l_rev_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;
954:
955: l_return_status VARCHAR2(1);

Line 952: l_active_flag_tbl pa_action_set_utils.varchar_tbl_type;

948: l_action_code_tbl pa_action_set_utils.varchar_tbl_type;
949: l_audit_display_attribute_tbl pa_action_set_utils.varchar_tbl_type;
950: l_audit_attribute_tbl pa_action_set_utils.varchar_tbl_type;
951: l_action_date_tbl pa_action_set_utils.date_tbl_type;
952: l_active_flag_tbl pa_action_set_utils.varchar_tbl_type;
953: l_rev_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;
954:
955: l_return_status VARCHAR2(1);
956:

Line 953: l_rev_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;

949: l_audit_display_attribute_tbl pa_action_set_utils.varchar_tbl_type;
950: l_audit_attribute_tbl pa_action_set_utils.varchar_tbl_type;
951: l_action_date_tbl pa_action_set_utils.date_tbl_type;
952: l_active_flag_tbl pa_action_set_utils.varchar_tbl_type;
953: l_rev_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;
954:
955: l_return_status VARCHAR2(1);
956:
957: BEGIN

Line 959: l_action_set_details_rec := PA_ACTION_SET_UTILS.get_action_set_details(p_action_set_line_id => p_action_set_line_id);

955: l_return_status VARCHAR2(1);
956:
957: BEGIN
958:
959: l_action_set_details_rec := PA_ACTION_SET_UTILS.get_action_set_details(p_action_set_line_id => p_action_set_line_id);
960:
961: l_active_audit_lines_tbl := PA_ACTION_SET_UTILS.get_active_audit_lines(p_action_set_line_id => p_action_set_line_id);
962:
963: IF l_active_audit_lines_tbl.COUNT > 0 THEN

Line 961: l_active_audit_lines_tbl := PA_ACTION_SET_UTILS.get_active_audit_lines(p_action_set_line_id => p_action_set_line_id);

957: BEGIN
958:
959: l_action_set_details_rec := PA_ACTION_SET_UTILS.get_action_set_details(p_action_set_line_id => p_action_set_line_id);
960:
961: l_active_audit_lines_tbl := PA_ACTION_SET_UTILS.get_active_audit_lines(p_action_set_line_id => p_action_set_line_id);
962:
963: IF l_active_audit_lines_tbl.COUNT > 0 THEN
964:
965: FOR i IN l_active_audit_lines_tbl.FIRST .. l_active_audit_lines_tbl.LAST LOOP

Line 996: PROCEDURE bulk_insert_audit_lines(p_audit_lines_tbl IN pa_action_set_utils.insert_audit_lines_tbl_type,

992:
993: END;
994:
995:
996: PROCEDURE bulk_insert_audit_lines(p_audit_lines_tbl IN pa_action_set_utils.insert_audit_lines_tbl_type,
997: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE,
998: p_object_type IN pa_action_sets.object_type%TYPE,
999: p_object_id IN pa_action_sets.object_id%TYPE,
1000: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE,

Line 1005: l_audit_lines_tbl pa_action_set_utils.insert_audit_lines_tbl_type;

1001: p_status_code IN VARCHAR2,
1002: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1003: IS
1004:
1005: l_audit_lines_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
1006: l_reason_code_tbl pa_action_set_utils.varchar_tbl_type;
1007: l_action_code_tbl pa_action_set_utils.varchar_tbl_type;
1008: l_audit_display_attribute_tbl pa_action_set_utils.varchar_tbl_type;
1009: l_audit_attribute_tbl pa_action_set_utils.varchar_tbl_type;

Line 1006: l_reason_code_tbl pa_action_set_utils.varchar_tbl_type;

1002: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1003: IS
1004:
1005: l_audit_lines_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
1006: l_reason_code_tbl pa_action_set_utils.varchar_tbl_type;
1007: l_action_code_tbl pa_action_set_utils.varchar_tbl_type;
1008: l_audit_display_attribute_tbl pa_action_set_utils.varchar_tbl_type;
1009: l_audit_attribute_tbl pa_action_set_utils.varchar_tbl_type;
1010: l_rev_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;

Line 1007: l_action_code_tbl pa_action_set_utils.varchar_tbl_type;

1003: IS
1004:
1005: l_audit_lines_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
1006: l_reason_code_tbl pa_action_set_utils.varchar_tbl_type;
1007: l_action_code_tbl pa_action_set_utils.varchar_tbl_type;
1008: l_audit_display_attribute_tbl pa_action_set_utils.varchar_tbl_type;
1009: l_audit_attribute_tbl pa_action_set_utils.varchar_tbl_type;
1010: l_rev_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;
1011: l_encoded_error_message_tbl pa_action_set_utils.varchar_tbl_type;

Line 1008: l_audit_display_attribute_tbl pa_action_set_utils.varchar_tbl_type;

1004:
1005: l_audit_lines_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
1006: l_reason_code_tbl pa_action_set_utils.varchar_tbl_type;
1007: l_action_code_tbl pa_action_set_utils.varchar_tbl_type;
1008: l_audit_display_attribute_tbl pa_action_set_utils.varchar_tbl_type;
1009: l_audit_attribute_tbl pa_action_set_utils.varchar_tbl_type;
1010: l_rev_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;
1011: l_encoded_error_message_tbl pa_action_set_utils.varchar_tbl_type;
1012:

Line 1009: l_audit_attribute_tbl pa_action_set_utils.varchar_tbl_type;

1005: l_audit_lines_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
1006: l_reason_code_tbl pa_action_set_utils.varchar_tbl_type;
1007: l_action_code_tbl pa_action_set_utils.varchar_tbl_type;
1008: l_audit_display_attribute_tbl pa_action_set_utils.varchar_tbl_type;
1009: l_audit_attribute_tbl pa_action_set_utils.varchar_tbl_type;
1010: l_rev_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;
1011: l_encoded_error_message_tbl pa_action_set_utils.varchar_tbl_type;
1012:
1013: BEGIN

Line 1010: l_rev_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;

1006: l_reason_code_tbl pa_action_set_utils.varchar_tbl_type;
1007: l_action_code_tbl pa_action_set_utils.varchar_tbl_type;
1008: l_audit_display_attribute_tbl pa_action_set_utils.varchar_tbl_type;
1009: l_audit_attribute_tbl pa_action_set_utils.varchar_tbl_type;
1010: l_rev_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;
1011: l_encoded_error_message_tbl pa_action_set_utils.varchar_tbl_type;
1012:
1013: BEGIN
1014:

Line 1011: l_encoded_error_message_tbl pa_action_set_utils.varchar_tbl_type;

1007: l_action_code_tbl pa_action_set_utils.varchar_tbl_type;
1008: l_audit_display_attribute_tbl pa_action_set_utils.varchar_tbl_type;
1009: l_audit_attribute_tbl pa_action_set_utils.varchar_tbl_type;
1010: l_rev_action_set_line_id_tbl pa_action_set_utils.number_tbl_type;
1011: l_encoded_error_message_tbl pa_action_set_utils.varchar_tbl_type;
1012:
1013: BEGIN
1014:
1015: IF p_status_code = 'REVERSED' THEN

Line 1100: PROCEDURE bulk_update_line_number(p_action_set_line_id_tbl IN pa_action_set_utils.number_tbl_type,

1096:
1097: END;
1098:
1099:
1100: PROCEDURE bulk_update_line_number(p_action_set_line_id_tbl IN pa_action_set_utils.number_tbl_type,
1101: p_line_number_tbl IN pa_action_set_utils.number_tbl_type,
1102: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1103: IS
1104:

Line 1101: p_line_number_tbl IN pa_action_set_utils.number_tbl_type,

1097: END;
1098:
1099:
1100: PROCEDURE bulk_update_line_number(p_action_set_line_id_tbl IN pa_action_set_utils.number_tbl_type,
1101: p_line_number_tbl IN pa_action_set_utils.number_tbl_type,
1102: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1103: IS
1104:
1105: TYPE rowid_tbl IS TABLE OF ROWID

Line 1149: PROCEDURE bulk_update_condition_date(p_action_line_condition_id_tbl IN pa_action_set_utils.number_tbl_type,

1145: RAISE;
1146:
1147: END;
1148:
1149: PROCEDURE bulk_update_condition_date(p_action_line_condition_id_tbl IN pa_action_set_utils.number_tbl_type,
1150: p_condition_date_tbl IN pa_action_set_utils.date_tbl_type,
1151: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1152: IS
1153:

Line 1150: p_condition_date_tbl IN pa_action_set_utils.date_tbl_type,

1146:
1147: END;
1148:
1149: PROCEDURE bulk_update_condition_date(p_action_line_condition_id_tbl IN pa_action_set_utils.number_tbl_type,
1150: p_condition_date_tbl IN pa_action_set_utils.date_tbl_type,
1151: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1152: IS
1153:
1154: TYPE rowid_tbl IS TABLE OF ROWID

Line 1198: PROCEDURE bulk_update_line_status(p_action_set_line_id_tbl IN pa_action_set_utils.number_tbl_type,

1194: RAISE;
1195:
1196: END;
1197:
1198: PROCEDURE bulk_update_line_status(p_action_set_line_id_tbl IN pa_action_set_utils.number_tbl_type,
1199: p_line_status_tbl IN pa_action_set_utils.varchar_tbl_type,
1200: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1201: IS
1202:

Line 1199: p_line_status_tbl IN pa_action_set_utils.varchar_tbl_type,

1195:
1196: END;
1197:
1198: PROCEDURE bulk_update_line_status(p_action_set_line_id_tbl IN pa_action_set_utils.number_tbl_type,
1199: p_line_status_tbl IN pa_action_set_utils.varchar_tbl_type,
1200: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1201: IS
1202:
1203: TYPE rowid_tbl IS TABLE OF ROWID

Line 1256: l_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type;

1252: IS
1253:
1254: l_return_status VARCHAR2(1);
1255: l_action_set_line_rec pa_action_set_lines%ROWTYPE;
1256: l_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type;
1257: l_action_line_audit_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
1258: l_action_line_complete_flag VARCHAR2(1);
1259: l_action_line_result_code VARCHAR2(240);
1260: l_action_set_details_rec pa_action_sets%ROWTYPE;

Line 1257: l_action_line_audit_tbl pa_action_set_utils.insert_audit_lines_tbl_type;

1253:
1254: l_return_status VARCHAR2(1);
1255: l_action_set_line_rec pa_action_set_lines%ROWTYPE;
1256: l_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type;
1257: l_action_line_audit_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
1258: l_action_line_complete_flag VARCHAR2(1);
1259: l_action_line_result_code VARCHAR2(240);
1260: l_action_set_details_rec pa_action_sets%ROWTYPE;
1261: l_audit_status_code VARCHAR2(30);

Line 1285: l_action_set_details_rec := PA_ACTION_SET_UTILS.get_action_set_details(p_action_set_line_id => p_action_set_line_id);

1281: ,x_msg => 'Beginning of Perform_Action_Set_Line pvt'
1282: ,x_log_level => 5);
1283: END IF;
1284:
1285: l_action_set_details_rec := PA_ACTION_SET_UTILS.get_action_set_details(p_action_set_line_id => p_action_set_line_id);
1286:
1287: l_action_set_line_rec := PA_ACTION_SET_UTILS.get_action_set_line(p_action_set_line_id => p_action_set_line_id);
1288:
1289: l_action_line_conditions_tbl := PA_ACTION_SET_UTILS.get_action_line_conditions(p_action_set_line_id => p_action_set_line_id);

Line 1287: l_action_set_line_rec := PA_ACTION_SET_UTILS.get_action_set_line(p_action_set_line_id => p_action_set_line_id);

1283: END IF;
1284:
1285: l_action_set_details_rec := PA_ACTION_SET_UTILS.get_action_set_details(p_action_set_line_id => p_action_set_line_id);
1286:
1287: l_action_set_line_rec := PA_ACTION_SET_UTILS.get_action_set_line(p_action_set_line_id => p_action_set_line_id);
1288:
1289: l_action_line_conditions_tbl := PA_ACTION_SET_UTILS.get_action_line_conditions(p_action_set_line_id => p_action_set_line_id);
1290:
1291: --Log Message: 4403338

Line 1289: l_action_line_conditions_tbl := PA_ACTION_SET_UTILS.get_action_line_conditions(p_action_set_line_id => p_action_set_line_id);

1285: l_action_set_details_rec := PA_ACTION_SET_UTILS.get_action_set_details(p_action_set_line_id => p_action_set_line_id);
1286:
1287: l_action_set_line_rec := PA_ACTION_SET_UTILS.get_action_set_line(p_action_set_line_id => p_action_set_line_id);
1288:
1289: l_action_line_conditions_tbl := PA_ACTION_SET_UTILS.get_action_line_conditions(p_action_set_line_id => p_action_set_line_id);
1290:
1291: --Log Message: 4403338
1292: IF l_debug_mode = 'Y' THEN
1293: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Perform_Action_Set_Line.begin'

Line 1313: IF l_action_line_result_code = PA_ACTION_SET_UTILS.G_PERFORMED_COMPLETE THEN

1309: ,x_msg => 'After calling PA_ACTION_SETS_DYN.perform_action_set_line'
1310: ,x_log_level => 5);
1311: END IF;
1312:
1313: IF l_action_line_result_code = PA_ACTION_SET_UTILS.G_PERFORMED_COMPLETE THEN
1314:
1315: l_audit_status_code := 'PERFORMED';
1316:
1317: l_new_line_status_code := 'COMPLETE';

Line 1319: ELSIF l_action_line_result_code = PA_ACTION_SET_UTILS.G_PERFORMED_ACTIVE THEN

1315: l_audit_status_code := 'PERFORMED';
1316:
1317: l_new_line_status_code := 'COMPLETE';
1318:
1319: ELSIF l_action_line_result_code = PA_ACTION_SET_UTILS.G_PERFORMED_ACTIVE THEN
1320:
1321: l_audit_status_code := 'PERFORMED';
1322:
1323: l_new_line_status_code := 'ACTIVE';

Line 1325: ELSIF l_action_line_result_code = PA_ACTION_SET_UTILS.G_REVERSED_DEFAULT_AUDIT THEN

1321: l_audit_status_code := 'PERFORMED';
1322:
1323: l_new_line_status_code := 'ACTIVE';
1324:
1325: ELSIF l_action_line_result_code = PA_ACTION_SET_UTILS.G_REVERSED_DEFAULT_AUDIT THEN
1326:
1327: l_action_line_audit_tbl := get_def_reverse_audit_lines(p_action_set_line_id => p_action_set_line_id
1328: ,p_reason => 'REVERSED');
1329:

Line 1334: ELSIF l_action_line_result_code = PA_ACTION_SET_UTILS.G_REVERSED_CUSTOM_AUDIT THEN

1330: l_audit_status_code := 'REVERSED';
1331:
1332: l_new_line_status_code := 'REVERSED';
1333:
1334: ELSIF l_action_line_result_code = PA_ACTION_SET_UTILS.G_REVERSED_CUSTOM_AUDIT THEN
1335:
1336: l_audit_status_code := 'REVERSED';
1337:
1338: l_new_line_status_code := 'REVERSED';

Line 1340: ELSIF l_action_line_result_code = PA_ACTION_SET_UTILS.G_UPDATED_DEFAULT_AUDIT THEN

1336: l_audit_status_code := 'REVERSED';
1337:
1338: l_new_line_status_code := 'REVERSED';
1339:
1340: ELSIF l_action_line_result_code = PA_ACTION_SET_UTILS.G_UPDATED_DEFAULT_AUDIT THEN
1341:
1342: l_action_line_audit_tbl := get_def_reverse_audit_lines(p_action_set_line_id => p_action_set_line_id
1343: ,p_reason => 'UPDATED');
1344:

Line 1349: ELSIF l_action_line_result_code = PA_ACTION_SET_UTILS.G_UPDATED_CUSTOM_AUDIT THEN

1345: l_audit_status_code := 'REVERSED';
1346:
1347: l_new_line_status_code := 'PENDING';
1348:
1349: ELSIF l_action_line_result_code = PA_ACTION_SET_UTILS.G_UPDATED_CUSTOM_AUDIT THEN
1350:
1351: l_audit_status_code := 'REVERSED';
1352:
1353: l_new_line_status_code := 'PENDING';

Line 1367: IF l_action_line_result_code <> PA_ACTION_SET_UTILS.G_NOT_PERFORMED THEN

1363: END IF;
1364: */
1365:
1366:
1367: IF l_action_line_result_code <> PA_ACTION_SET_UTILS.G_NOT_PERFORMED THEN
1368:
1369:
1370: PA_ACTION_SET_LINES_PKG.update_row
1371: (p_action_set_line_id => p_action_set_line_id,