APPS.PA_CI_SUPPLIER_UTILS dependencies on PA_CI_IMPACTS

Line 898: FROM pa_ci_impacts pci

894: l_ci_impact_id number;
895: l_debug_mode varchar2(1) := 'N';
896: cursor cur_impact_id IS
897: SELECT ci_impact_id
898: FROM pa_ci_impacts pci
899: WHERE pci.ci_id = p_ci_id
900: AND pci.IMPACT_TYPE_CODE = 'SUPPLIER';
901:
902:

Line 985: IF ( NOT pa_ci_impacts_util.is_impact_exist

981:
982: If p_RECORD_STATUS = 'NEW' then
983:
984: /* Bug fix: 2634102 create impact line if not exists*/
985: IF ( NOT pa_ci_impacts_util.is_impact_exist
986: (p_ci_id => p_ci_id,
987: p_impact_type_code => 'SUPPLIER') ) THEN
988:
989: IF l_debug_mode = 'Y' THEN

Line 990: print_msg('Calling PA_CI_IMPACTS_pub.create_ci_impact Api');

986: (p_ci_id => p_ci_id,
987: p_impact_type_code => 'SUPPLIER') ) THEN
988:
989: IF l_debug_mode = 'Y' THEN
990: print_msg('Calling PA_CI_IMPACTS_pub.create_ci_impact Api');
991: End If;
992:
993: PA_CI_IMPACTS_pub.create_ci_impact(
994: p_ci_id => p_ci_id,

Line 993: PA_CI_IMPACTS_pub.create_ci_impact(

989: IF l_debug_mode = 'Y' THEN
990: print_msg('Calling PA_CI_IMPACTS_pub.create_ci_impact Api');
991: End If;
992:
993: PA_CI_IMPACTS_pub.create_ci_impact(
994: p_ci_id => p_ci_id,
995: p_impact_type_code => 'SUPPLIER',
996: p_status_code => 'CI_IMPACT_PENDING',
997: p_commit => 'F',

Line 1189: IF ( NOT pa_ci_impacts_util.is_impact_exist

1185: IF l_debug_mode = 'Y' THEN
1186: print_msg('Assigning citransactionid ='||p_ci_transaction_id);
1187: End If;
1188: /* Bug fix: 2634102 create impact line if not exists*/
1189: IF ( NOT pa_ci_impacts_util.is_impact_exist
1190: (p_ci_id => p_ci_id,
1191: p_impact_type_code => 'SUPPLIER') ) THEN
1192: IF l_debug_mode = 'Y' THEN
1193: print_msg('Calling PA_CI_IMPACTS_pub.create_ci_impact in Update');

Line 1193: print_msg('Calling PA_CI_IMPACTS_pub.create_ci_impact in Update');

1189: IF ( NOT pa_ci_impacts_util.is_impact_exist
1190: (p_ci_id => p_ci_id,
1191: p_impact_type_code => 'SUPPLIER') ) THEN
1192: IF l_debug_mode = 'Y' THEN
1193: print_msg('Calling PA_CI_IMPACTS_pub.create_ci_impact in Update');
1194: End If;
1195:
1196: PA_CI_IMPACTS_pub.create_ci_impact(
1197: p_ci_id => p_ci_id,

Line 1196: PA_CI_IMPACTS_pub.create_ci_impact(

1192: IF l_debug_mode = 'Y' THEN
1193: print_msg('Calling PA_CI_IMPACTS_pub.create_ci_impact in Update');
1194: End If;
1195:
1196: PA_CI_IMPACTS_pub.create_ci_impact(
1197: p_ci_id => p_ci_id,
1198: p_impact_type_code => 'SUPPLIER',
1199: p_status_code => 'CI_IMPACT_PENDING',
1200: p_commit => 'F',

Line 1447: ** deleting records from pa_ci_impacts

1443:
1444: /** This Api checks transactions exists in supplier impact details
1445: ** and returns success 'S' if there are no transactions exists
1446: ** returns Error if transactions exists. This api is called before
1447: ** deleting records from pa_ci_impacts
1448: **/
1449:
1450: PROCEDURE IS_SI_DELETE_OK(p_ci_id IN NUMBER
1451: ,x_return_status OUT NOCOPY VARCHAR2

Line 1553: -- Indicates records exists in SI table so donot delete header lines (pa_ci_impacts)

1549: ,x_msg_count =>l_msg_count
1550: );
1551:
1552: If l_return_status <> 'S' then
1553: -- Indicates records exists in SI table so donot delete header lines (pa_ci_impacts)
1554: l_return_flag := 'N';
1555: Else
1556: -- No records exists in SI table so delete header lines (pa_ci_impacts)
1557: l_return_flag := 'Y';

Line 1556: -- No records exists in SI table so delete header lines (pa_ci_impacts)

1552: If l_return_status <> 'S' then
1553: -- Indicates records exists in SI table so donot delete header lines (pa_ci_impacts)
1554: l_return_flag := 'N';
1555: Else
1556: -- No records exists in SI table so delete header lines (pa_ci_impacts)
1557: l_return_flag := 'Y';
1558: End If;
1559:
1560: RETURN l_return_flag;