APPS.GMF_GLSYNCH dependencies on SY_GEOG_MST

Line 810: /* Insert the state_code if it is not already there in sy_geog_mst */

806: ' ',
807: 0,
808: 0);
809: END IF;
810: /* Insert the state_code if it is not already there in sy_geog_mst */
811: IF pi_state_code is not NULL THEN
812: INSERT into SY_GEOG_MST(
813: geog_type,
814: geog_code,

Line 812: INSERT into SY_GEOG_MST(

808: 0);
809: END IF;
810: /* Insert the state_code if it is not already there in sy_geog_mst */
811: IF pi_state_code is not NULL THEN
812: INSERT into SY_GEOG_MST(
813: geog_type,
814: geog_code,
815: geog_desc,
816: delete_mark,

Line 834: SELECT 1 FROM SY_GEOG_MST

830: nvl(pi_date_modified, to_date(2440588,'J')),
831: nvl(pi_modified_by,0)
832: FROM SYS.DUAL
833: WHERE not exists(
834: SELECT 1 FROM SY_GEOG_MST
835: WHERE geog_type = 2 and geog_code = pi_state_code);
836: END IF;
837: /* Insert the Country Code if it is not already there in sy_geog_mst */
838: IF pi_country_code is not NULL THEN

Line 837: /* Insert the Country Code if it is not already there in sy_geog_mst */

833: WHERE not exists(
834: SELECT 1 FROM SY_GEOG_MST
835: WHERE geog_type = 2 and geog_code = pi_state_code);
836: END IF;
837: /* Insert the Country Code if it is not already there in sy_geog_mst */
838: IF pi_country_code is not NULL THEN
839: INSERT into SY_GEOG_MST(
840: geog_type,
841: geog_code,

Line 839: INSERT into SY_GEOG_MST(

835: WHERE geog_type = 2 and geog_code = pi_state_code);
836: END IF;
837: /* Insert the Country Code if it is not already there in sy_geog_mst */
838: IF pi_country_code is not NULL THEN
839: INSERT into SY_GEOG_MST(
840: geog_type,
841: geog_code,
842: geog_desc,
843: delete_mark,

Line 862: SELECT 1 FROM SY_GEOG_MST

858: nvl(pi_modified_by,0)
859: FROM fnd_territories_vl
860: WHERE territory_code = pi_country_code and
861: not exists(
862: SELECT 1 FROM SY_GEOG_MST
863: WHERE geog_type = 1 and geog_code = pi_country_code);
864: END IF;
865: END; /* Save_Adddr */
866: