DBA Data[Home] [Help]

APPS.PA_ADVERTISEMENTS_PUB dependencies on PA_ACTION_SETS_PVT

Line 703: PA_ACTION_SETS_PVT.Bulk_Update_Line_Status(

699: AND asl.action_set_line_id = aslc.action_set_line_id
700: AND aslc.condition_date > SYSDATE;
701:
702: -- bulk udpate advertisement action line status and condition date
703: PA_ACTION_SETS_PVT.Bulk_Update_Line_Status(
704: p_action_set_line_id_tbl => l_action_set_line_id_tbl
705: ,p_line_status_tbl => l_action_status_code_tbl
706: ,x_return_status => l_return_status
707: );

Line 712: PA_ACTION_SETS_PVT.Bulk_Update_Condition_Date(

708: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: END IF;
711:
712: PA_ACTION_SETS_PVT.Bulk_Update_Condition_Date(
713: p_action_line_condition_id_tbl => l_action_line_cond_id_tbl
714: ,p_condition_date_tbl => l_condition_date_tbl
715: ,x_return_status => l_return_status
716: );

Line 743: PA_ACTION_SETS_PVT.Bulk_Update_Line_Status(

739: AND nvl(asl.line_deleted_flag, 'N') = 'N'
740: AND asl.action_set_line_id = aslc.action_set_line_id
741: AND aslc.condition_date > SYSDATE;
742:
743: PA_ACTION_SETS_PVT.Bulk_Update_Line_Status(
744: p_action_set_line_id_tbl => l_action_set_line_id_tbl
745: ,p_line_status_tbl => l_action_status_code_tbl
746: ,x_return_status => l_return_status
747: );

Line 752: PA_ACTION_SETS_PVT.Bulk_Update_Condition_Date(

748: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: END IF;
751:
752: PA_ACTION_SETS_PVT.Bulk_Update_Condition_Date(
753: p_action_line_condition_id_tbl => l_action_line_cond_id_tbl
754: ,p_condition_date_tbl => l_condition_date_tbl
755: ,x_return_status => l_return_status
756: );