DBA Data[Home] [Help]

APPS.JTF_TERR_SERVICE_PUB dependencies on JTY_TERR_NVP_TRANS_GT

Line 178: DELETE jty_terr_nvp_trans_gt;

174: ' p_plan_end_date: ' || p_plan_end_date);
175: END IF;
176:
177: /* delete and insert all the attributes into the trans table as name - value pair */
178: DELETE jty_terr_nvp_trans_gt;
179: INSERT INTO jty_terr_nvp_trans_gt (
180: attribute_name
181: ,num_value
182: ,char_value

Line 179: INSERT INTO jty_terr_nvp_trans_gt (

175: END IF;
176:
177: /* delete and insert all the attributes into the trans table as name - value pair */
178: DELETE jty_terr_nvp_trans_gt;
179: INSERT INTO jty_terr_nvp_trans_gt (
180: attribute_name
181: ,num_value
182: ,char_value
183: ,date_value )

Line 700: DELETE jty_terr_nvp_trans_gt;

696: ' p_plan_end_date: ' || p_plan_end_date);
697: END IF;
698:
699: /* delete and insert all the attributes into the trans table as name - value pair */
700: DELETE jty_terr_nvp_trans_gt;
701: INSERT INTO jty_terr_nvp_trans_gt (
702: attribute_name
703: ,num_value
704: ,char_value

Line 701: INSERT INTO jty_terr_nvp_trans_gt (

697: END IF;
698:
699: /* delete and insert all the attributes into the trans table as name - value pair */
700: DELETE jty_terr_nvp_trans_gt;
701: INSERT INTO jty_terr_nvp_trans_gt (
702: attribute_name
703: ,num_value
704: ,char_value
705: ,date_value )