APPS.PA_ACTION_SETS_PVT dependencies on PA_ACTION_SET_LINE_COND

Line 596: PA_ACTION_SET_LINE_COND_PKG.Insert_Row

592:
593: FOR i IN p_condition_tbl.FIRST .. p_condition_tbl.LAST LOOP
594:
595:
596: PA_ACTION_SET_LINE_COND_PKG.Insert_Row
597: (p_action_set_line_id => l_action_set_line_id
598: ,p_condition_date => p_condition_tbl(i).condition_date
599: ,p_condition_code => p_condition_tbl(i).condition_code
600: ,p_description => p_condition_tbl(i).description

Line 744: PA_ACTION_SET_LINE_COND_PKG.Update_Row

740:
741:
742: FOR i IN p_condition_tbl.FIRST .. p_condition_tbl.LAST LOOP
743:
744: PA_ACTION_SET_LINE_COND_PKG.Update_Row
745: (p_action_set_line_condition_id => p_condition_tbl(i).action_set_line_condition_id
746: ,p_condition_date => p_condition_tbl(i).condition_date
747: ,p_condition_code => p_condition_tbl(i).condition_code
748: ,p_description => p_condition_tbl(i).description

Line 869: PA_ACTION_SET_LINE_COND_PKG.delete_row

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,
872: x_return_status => l_return_status);
873: END LOOP;

Line 897: PA_ACTION_SET_LINE_COND_PKG.delete_row

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,
899: p_record_version_number => p_record_version_number,
900: x_return_status => l_return_status);
901:

Line 1169: FROM pa_action_set_line_cond

1165:
1166: FOR i IN p_action_line_condition_id_tbl.FIRST .. p_action_line_condition_id_tbl.LAST LOOP
1167:
1168: SELECT rowid INTO l_rowid_tbl(i)
1169: FROM pa_action_set_line_cond
1170: WHERE action_set_line_condition_id = p_action_line_condition_id_tbl(i)
1171: FOR UPDATE NOWAIT;
1172:
1173: END LOOP;

Line 1176: UPDATE pa_action_set_line_cond

1172:
1173: END LOOP;
1174:
1175: FORALL i IN l_rowid_tbl.FIRST .. l_rowid_tbl.LAST
1176: UPDATE pa_action_set_line_cond
1177: SET condition_date = p_condition_date_tbl(i)
1178: WHERE rowid = l_rowid_tbl(i);
1179:
1180: END IF;