DBA Data[Home] [Help]

APPS.JTF_TERR_NAMEACC_PUB dependencies on JTY_ASSIGN_REALTIME_PUB

Line 59: lp_trans_Rec JTY_ASSIGN_REALTIME_PUB.bulk_trans_id_type;

55: lP_role VARCHAR2(60) := NULL;
56: lX_Return_Status VARCHAR2(1);
57: lX_Msg_Count NUMBER;
58: lX_Msg_Data VARCHAR2(2000);
59: lp_trans_Rec JTY_ASSIGN_REALTIME_PUB.bulk_trans_id_type;
60: -- JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
61: lx_winners_rec JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type ;
62: -- JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;
63: l_api_name CONSTANT VARCHAR2(30) := 'Set_Winners_tbl';

Line 61: lx_winners_rec JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type ;

57: lX_Msg_Count NUMBER;
58: lX_Msg_Data VARCHAR2(2000);
59: lp_trans_Rec JTY_ASSIGN_REALTIME_PUB.bulk_trans_id_type;
60: -- JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
61: lx_winners_rec JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type ;
62: -- JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;
63: l_api_name CONSTANT VARCHAR2(30) := 'Set_Winners_tbl';
64: l_api_version_number CONSTANT NUMBER := 1.0;
65: l_return_status VARCHAR2(1);

Line 62: -- JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;

58: lX_Msg_Data VARCHAR2(2000);
59: lp_trans_Rec JTY_ASSIGN_REALTIME_PUB.bulk_trans_id_type;
60: -- JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
61: lx_winners_rec JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type ;
62: -- JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;
63: l_api_name CONSTANT VARCHAR2(30) := 'Set_Winners_tbl';
64: l_api_version_number CONSTANT NUMBER := 1.0;
65: l_return_status VARCHAR2(1);
66: l_Counter NUMBER := 0;

Line 144: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',

140: IF p_api_mode = 'CURRENT'
141: THEN
142: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
143: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
144: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
145: 'Calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners in RealTime Mode');
146: END IF;
147: JTY_ASSIGN_REALTIME_PUB.get_winners(
148: P_api_version_number => 1.0,

Line 145: 'Calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners in RealTime Mode');

141: THEN
142: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
143: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
144: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
145: 'Calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners in RealTime Mode');
146: END IF;
147: JTY_ASSIGN_REALTIME_PUB.get_winners(
148: P_api_version_number => 1.0,
149: P_init_msg_list => FND_API.G_FALSE,

Line 147: JTY_ASSIGN_REALTIME_PUB.get_winners(

143: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
144: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
145: 'Calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners in RealTime Mode');
146: END IF;
147: JTY_ASSIGN_REALTIME_PUB.get_winners(
148: P_api_version_number => 1.0,
149: P_init_msg_list => FND_API.G_FALSE,
150: P_source_id => -1001,
151: P_trans_id => -1002,

Line 166: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',

162: X_winners_rec => lx_winners_rec);
163: ELSE
164: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
165: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
166: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
167: 'Calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners in Date EFfective Mode');
168: END IF;
169: JTY_ASSIGN_REALTIME_PUB.get_winners(
170: P_api_version_number => 1.0,

Line 167: 'Calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners in Date EFfective Mode');

163: ELSE
164: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
165: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
166: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
167: 'Calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners in Date EFfective Mode');
168: END IF;
169: JTY_ASSIGN_REALTIME_PUB.get_winners(
170: P_api_version_number => 1.0,
171: P_init_msg_list => FND_API.G_FALSE,

Line 169: JTY_ASSIGN_REALTIME_PUB.get_winners(

165: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
166: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
167: 'Calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners in Date EFfective Mode');
168: END IF;
169: JTY_ASSIGN_REALTIME_PUB.get_winners(
170: P_api_version_number => 1.0,
171: P_init_msg_list => FND_API.G_FALSE,
172: P_source_id => -1001,
173: P_trans_id => -1002,

Line 190: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',

186: IF (lx_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
187: -- debug message
188: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
189: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
190: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
191: 'JTY_ASSIGN_REALTIME_PUB.get_winners API has failed');
192: END IF;
193: RAISE FND_API.G_EXC_ERROR;
194: END IF;

Line 191: 'JTY_ASSIGN_REALTIME_PUB.get_winners API has failed');

187: -- debug message
188: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
189: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
190: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
191: 'JTY_ASSIGN_REALTIME_PUB.get_winners API has failed');
192: END IF;
193: RAISE FND_API.G_EXC_ERROR;
194: END IF;
195: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 197: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',

193: RAISE FND_API.G_EXC_ERROR;
194: END IF;
195: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
196: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
197: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
198: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners');
199: END IF;
200: /*
201: JTF_TERR_ASSIGN_PUB.get_winners

Line 198: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners');

194: END IF;
195: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
196: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
197: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
198: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners');
199: END IF;
200: /*
201: JTF_TERR_ASSIGN_PUB.get_winners
202: ( p_api_version_number => p_api_version_number,