[Home] [Help]
67: BEGIN
68: IF (p_mode LIKE 'DATE EFFECTIVE%') THEN
69: SELECT tup.real_time_match_dea_sql
70: INTO l_matching_sql
71: FROM jty_trans_usg_pgm_details tup
72: WHERE tup.source_id = p_source_id
73: AND tup.trans_type_id = p_trans_id
74: AND tup.program_name = p_program_name;
75:
75:
76: ELSIF (p_mode LIKE 'REAL TIME%') THEN
77: SELECT tup.real_time_match_sql
78: INTO l_matching_sql
79: FROM jty_trans_usg_pgm_details tup
80: WHERE tup.source_id = p_source_id
81: AND tup.trans_type_id = p_trans_id
82: AND tup.program_name = p_program_name;
83:
1966: /* Get the multi level winning flag corresponding */
1967: /* to the usage, transaction type and program name */
1968: SELECT tup.multi_level_winning_flag
1969: INTO l_multi_level_winning_flag
1970: FROM jty_trans_usg_pgm_details tup
1971: WHERE tup.source_id = p_source_id
1972: AND tup.trans_type_id = p_trans_id
1973: AND tup.program_name = p_program_name;
1974:
2033: END IF;
2034:
2035: WHEN NO_DATA_FOUND THEN
2036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2037: x_msg_data := 'No record in the table jty_trans_usg_pgm_details for the usage : ' || p_source_id ||
2038: ', transaction type : ' || p_trans_id || ' and program name : ' || p_program_name;
2039: x_msg_count := 1;
2040: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2041: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2170: /* to the usage, transaction type and program name */
2171: BEGIN
2172: SELECT tup.real_time_trans_table_name
2173: INTO l_real_time_trans_table_name
2174: FROM jty_trans_usg_pgm_details tup
2175: WHERE tup.source_id = p_source_id
2176: AND tup.trans_type_id = p_trans_id
2177: AND tup.program_name = p_program_name;
2178: