DBA Data[Home] [Help]

APPS.JTF_TERR_SERVICE_PUB dependencies on JTY_TERR_NVP_TRANS_GT

Line 182: DELETE jty_terr_nvp_trans_gt;

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

Line 183: INSERT INTO jty_terr_nvp_trans_gt (

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

Line 729: DELETE jty_terr_nvp_trans_gt;

725: ' System Id : ' || p_TerrSrvTask_Rec.SQUAL_NUM60);
726: END IF;
727:
728: /* delete and insert all the attributes into the trans table as name - value pair */
729: DELETE jty_terr_nvp_trans_gt;
730: INSERT INTO jty_terr_nvp_trans_gt (
731: attribute_name
732: ,num_value
733: ,char_value

Line 730: INSERT INTO jty_terr_nvp_trans_gt (

726: END IF;
727:
728: /* delete and insert all the attributes into the trans table as name - value pair */
729: DELETE jty_terr_nvp_trans_gt;
730: INSERT INTO jty_terr_nvp_trans_gt (
731: attribute_name
732: ,num_value
733: ,char_value
734: ,date_value )