DBA Data[Home] [Help]

APPS.JTY_ASSIGN_REALTIME_PUB dependencies on JTY_TERR_NVP_TRANS_GT

Line 2290: INSERT INTO jty_terr_nvp_trans_gt (

2286: END;
2287:
2288: ELSIF (p_param_passing_mechanism = 'PBV') THEN -- if parameter passing mechanism is pass by value
2289: FORALL i IN p_name_value_pair.attribute_name.FIRST .. p_name_value_pair.attribute_name.LAST
2290: INSERT INTO jty_terr_nvp_trans_gt (
2291: attribute_name
2292: ,char_value
2293: ,num_value
2294: ,date_value )

Line 2305: FROM jty_terr_nvp_trans_gt;

2301: -- debug message
2302: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2303: SELECT COUNT(*)
2304: INTO l_trans_no_of_records
2305: FROM jty_terr_nvp_trans_gt;
2306:
2307: FND_LOG.string(FND_LOG.LEVEL_EVENT,
2308: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners.insert_trans_data_pbv',
2309: 'Number of records inserted into TRANS table : ' || l_trans_no_of_records);