DBA Data[Home] [Help]

APPS.WSH_FTE_CONSTRAINT_FRAMEWORK dependencies on WSH_FTE_INTEGRATION

Line 748: wsh_debug_sv.log(l_module_name,'Calling WSH_FTE_INTEGRATION.get_cc_object_name for CONSTRAINT_OBJECT1_ID ');

744:
745: IF l_constraint_rec.CONSTRAINT_OBJECT1_ID IS NOT NULL THEN
746:
747: IF l_debug_on THEN
748: wsh_debug_sv.log(l_module_name,'Calling WSH_FTE_INTEGRATION.get_cc_object_name for CONSTRAINT_OBJECT1_ID ');
749: END IF;
750: x_obj1_display := WSH_FTE_INTEGRATION.get_cc_object_name(
751: p_object_type => l_constraint_rec.CONSTRAINT_OBJECT1_TYPE,
752: x_fac_company_name => l_fac_company_name,

Line 750: x_obj1_display := WSH_FTE_INTEGRATION.get_cc_object_name(

746:
747: IF l_debug_on THEN
748: wsh_debug_sv.log(l_module_name,'Calling WSH_FTE_INTEGRATION.get_cc_object_name for CONSTRAINT_OBJECT1_ID ');
749: END IF;
750: x_obj1_display := WSH_FTE_INTEGRATION.get_cc_object_name(
751: p_object_type => l_constraint_rec.CONSTRAINT_OBJECT1_TYPE,
752: x_fac_company_name => l_fac_company_name,
753: x_fac_company_type => l_fac_company_type,
754: p_object_parent_id => l_constraint_rec.OBJECT1_SOURCE_ID,

Line 760: wsh_debug_sv.log(l_module_name,'Calling WSH_FTE_INTEGRATION.get_cc_object_name for CONSTRAINT_OBJECT1_VALUE_CHAR ');

756:
757: ELSIF l_constraint_rec.CONSTRAINT_OBJECT1_VALUE_CHAR IS NOT NULL THEN
758:
759: IF l_debug_on THEN
760: wsh_debug_sv.log(l_module_name,'Calling WSH_FTE_INTEGRATION.get_cc_object_name for CONSTRAINT_OBJECT1_VALUE_CHAR ');
761: END IF;
762: x_obj1_display := WSH_FTE_INTEGRATION.get_cc_object_name(
763: p_object_type => l_constraint_rec.CONSTRAINT_OBJECT1_TYPE,
764: x_fac_company_name => l_fac_company_name,

Line 762: x_obj1_display := WSH_FTE_INTEGRATION.get_cc_object_name(

758:
759: IF l_debug_on THEN
760: wsh_debug_sv.log(l_module_name,'Calling WSH_FTE_INTEGRATION.get_cc_object_name for CONSTRAINT_OBJECT1_VALUE_CHAR ');
761: END IF;
762: x_obj1_display := WSH_FTE_INTEGRATION.get_cc_object_name(
763: p_object_type => l_constraint_rec.CONSTRAINT_OBJECT1_TYPE,
764: x_fac_company_name => l_fac_company_name,
765: x_fac_company_type => l_fac_company_type,
766: p_object_value_char => l_constraint_rec.CONSTRAINT_OBJECT1_VALUE_CHAR);

Line 783: wsh_debug_sv.log(l_module_name,'Calling WSH_FTE_INTEGRATION.get_cc_object_name for CONSTRAINT_OBJECT2_ID ');

779:
780: IF l_constraint_rec.CONSTRAINT_OBJECT2_ID IS NOT NULL THEN
781:
782: IF l_debug_on THEN
783: wsh_debug_sv.log(l_module_name,'Calling WSH_FTE_INTEGRATION.get_cc_object_name for CONSTRAINT_OBJECT2_ID ');
784: END IF;
785: x_obj2_display := WSH_FTE_INTEGRATION.get_cc_object_name(
786: p_object_type => l_constraint_rec.CONSTRAINT_OBJECT2_TYPE,
787: x_fac_company_name => l_fac_company_name,

Line 785: x_obj2_display := WSH_FTE_INTEGRATION.get_cc_object_name(

781:
782: IF l_debug_on THEN
783: wsh_debug_sv.log(l_module_name,'Calling WSH_FTE_INTEGRATION.get_cc_object_name for CONSTRAINT_OBJECT2_ID ');
784: END IF;
785: x_obj2_display := WSH_FTE_INTEGRATION.get_cc_object_name(
786: p_object_type => l_constraint_rec.CONSTRAINT_OBJECT2_TYPE,
787: x_fac_company_name => l_fac_company_name,
788: x_fac_company_type => l_fac_company_type,
789: p_object_parent_id => l_constraint_rec.OBJECT2_SOURCE_ID,

Line 795: wsh_debug_sv.log(l_module_name,'Calling WSH_FTE_INTEGRATION.get_cc_object_name for CONSTRAINT_OBJECT2_VALUE_CHAR ');

791:
792: ELSIF l_constraint_rec.CONSTRAINT_OBJECT2_VALUE_CHAR IS NOT NULL THEN
793:
794: IF l_debug_on THEN
795: wsh_debug_sv.log(l_module_name,'Calling WSH_FTE_INTEGRATION.get_cc_object_name for CONSTRAINT_OBJECT2_VALUE_CHAR ');
796: END IF;
797: x_obj2_display := WSH_FTE_INTEGRATION.get_cc_object_name(
798: p_object_type => l_constraint_rec.CONSTRAINT_OBJECT2_TYPE,
799: x_fac_company_name => l_fac_company_name,

Line 797: x_obj2_display := WSH_FTE_INTEGRATION.get_cc_object_name(

793:
794: IF l_debug_on THEN
795: wsh_debug_sv.log(l_module_name,'Calling WSH_FTE_INTEGRATION.get_cc_object_name for CONSTRAINT_OBJECT2_VALUE_CHAR ');
796: END IF;
797: x_obj2_display := WSH_FTE_INTEGRATION.get_cc_object_name(
798: p_object_type => l_constraint_rec.CONSTRAINT_OBJECT2_TYPE,
799: x_fac_company_name => l_fac_company_name,
800: x_fac_company_type => l_fac_company_type,
801: p_object_value_char => l_constraint_rec.CONSTRAINT_OBJECT2_VALUE_CHAR);

Line 819: x_obj1_parent_display := WSH_FTE_INTEGRATION.get_cc_object_name(

815: IF l_constraint_rec.OBJECT1_SOURCE_ID IS NOT NULL THEN
816:
817: -- Patch I : Supports only ORG as parent for Item
818:
819: x_obj1_parent_display := WSH_FTE_INTEGRATION.get_cc_object_name(
820: p_object_type => 'ORG',
821: x_fac_company_name => l_fac_company_name,
822: x_fac_company_type => l_fac_company_type ,
823: p_object_value_num => l_constraint_rec.OBJECT1_SOURCE_ID);

Line 833: x_obj2_parent_display := WSH_FTE_INTEGRATION.get_cc_object_name(

829: END IF;
830:
831: IF l_constraint_rec.OBJECT2_SOURCE_ID IS NOT NULL THEN
832:
833: x_obj2_parent_display := WSH_FTE_INTEGRATION.get_cc_object_name(
834: p_object_type => 'ORG',
835: x_fac_company_name => l_fac_company_name,
836: x_fac_company_type => l_fac_company_type ,
837: p_object_value_num => l_constraint_rec.OBJECT2_SOURCE_ID);

Line 7724: WSH_FTE_INTEGRATION.get_vehicle_type(

7720: END IF;
7721:
7722: IF (p_target_trip.VEHICLE_ITEM_ID IS NOT NULL AND p_target_trip.VEHICLE_ORGANIZATION_ID IS NOT NULL) THEN
7723:
7724: WSH_FTE_INTEGRATION.get_vehicle_type(
7725: p_vehicle_item_id => p_target_trip.VEHICLE_ITEM_ID,
7726: p_vehicle_org_id => p_target_trip.VEHICLE_ORGANIZATION_ID,
7727: x_vehicle_type_id => l_vehicle_type,
7728: x_return_status => l_return_status);

Line 10016: WSH_FTE_INTEGRATION.get_vehicle_type(

10012: END IF;
10013:
10014: IF (p_target_trip.VEHICLE_ITEM_ID IS NOT NULL AND p_target_trip.VEHICLE_ORGANIZATION_ID IS NOT NULL) THEN
10015:
10016: WSH_FTE_INTEGRATION.get_vehicle_type(
10017: p_vehicle_item_id => p_target_trip.VEHICLE_ITEM_ID,
10018: p_vehicle_org_id => p_target_trip.VEHICLE_ORGANIZATION_ID,
10019: x_vehicle_type_id => l_vehicle_type,
10020: x_return_status => l_return_status);

Line 12502: WSH_FTE_INTEGRATION.get_vehicle_type(

12498: END IF;
12499:
12500: IF (l_target_trip.VEHICLE_ITEM_ID IS NOT NULL AND l_target_trip.VEHICLE_ORGANIZATION_ID IS NOT NULL) THEN
12501:
12502: WSH_FTE_INTEGRATION.get_vehicle_type(
12503: p_vehicle_item_id => l_target_trip.VEHICLE_ITEM_ID,
12504: p_vehicle_org_id => l_target_trip.VEHICLE_ORGANIZATION_ID,
12505: x_vehicle_type_id => l_vehicle_type,
12506: x_return_status => l_return_status);

Line 16079: WSH_FTE_INTEGRATION.get_vehicle_type(

16075: END IF;
16076:
16077: IF (p_trip_info(j).VEHICLE_ITEM_ID IS NOT NULL AND p_trip_info(j).VEHICLE_ORGANIZATION_ID IS NOT NULL) THEN
16078:
16079: WSH_FTE_INTEGRATION.get_vehicle_type(
16080: p_vehicle_item_id => p_trip_info(j).VEHICLE_ITEM_ID,
16081: p_vehicle_org_id => p_trip_info(j).VEHICLE_ORGANIZATION_ID,
16082: x_vehicle_type_id => l_vehicle_type,
16083: x_return_status => l_return_status);

Line 17045: WSH_FTE_INTEGRATION.get_vehicle_type(

17041: END IF;
17042:
17043: IF (l_parent_trip_info(k).vehicle_item_id IS NOT NULL AND l_parent_trip_info(k).vehicle_organization_id IS NOT NULL) THEN
17044:
17045: WSH_FTE_INTEGRATION.get_vehicle_type(
17046: p_vehicle_item_id => l_parent_trip_info(k).vehicle_item_id,
17047: p_vehicle_org_id => l_parent_trip_info(k).vehicle_organization_id,
17048: x_vehicle_type_id => l_vehicle_type,
17049: x_return_status => l_return_status);