DBA Data[Home] [Help]

APPS.JTY_ASSIGN_BULK_PUB dependencies on JTY_TAE_CONTROL_PVT

Line 1260: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);

1256: ' L4 table name : ' || l_L4_target || ' L5 table name : ' || l_L5_target ||
1257: ' WT table name : ' || l_WT_target);
1258:
1259: /* set NOLOGGING on JTF_TAE_..._MATCHES and JTF_TAE_..._WINNERS tables */
1260: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);
1261: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_match_target);
1262: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_umatch_target);
1263: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winner_target);
1264: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);

Line 1261: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_match_target);

1257: ' WT table name : ' || l_WT_target);
1258:
1259: /* set NOLOGGING on JTF_TAE_..._MATCHES and JTF_TAE_..._WINNERS tables */
1260: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);
1261: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_match_target);
1262: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_umatch_target);
1263: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winner_target);
1264: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);
1265: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);

Line 1262: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_umatch_target);

1258:
1259: /* set NOLOGGING on JTF_TAE_..._MATCHES and JTF_TAE_..._WINNERS tables */
1260: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);
1261: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_match_target);
1262: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_umatch_target);
1263: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winner_target);
1264: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);
1265: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);
1266: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);

Line 1263: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winner_target);

1259: /* set NOLOGGING on JTF_TAE_..._MATCHES and JTF_TAE_..._WINNERS tables */
1260: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);
1261: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_match_target);
1262: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_umatch_target);
1263: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winner_target);
1264: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);
1265: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);
1266: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);
1267: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L3_target);

Line 1264: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);

1260: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);
1261: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_match_target);
1262: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_umatch_target);
1263: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winner_target);
1264: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);
1265: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);
1266: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);
1267: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L3_target);
1268: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L4_target);

Line 1265: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);

1261: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_match_target);
1262: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_umatch_target);
1263: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winner_target);
1264: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);
1265: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);
1266: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);
1267: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L3_target);
1268: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L4_target);
1269: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L5_target);

Line 1266: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);

1262: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_umatch_target);
1263: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winner_target);
1264: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);
1265: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);
1266: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);
1267: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L3_target);
1268: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L4_target);
1269: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L5_target);
1270: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_WT_target);

Line 1267: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L3_target);

1263: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winner_target);
1264: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);
1265: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);
1266: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);
1267: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L3_target);
1268: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L4_target);
1269: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L5_target);
1270: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_WT_target);
1271:

Line 1268: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L4_target);

1264: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);
1265: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);
1266: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);
1267: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L3_target);
1268: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L4_target);
1269: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L5_target);
1270: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_WT_target);
1271:
1272: /* Check for territories for this Usage/Transaction Type */

Line 1269: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L5_target);

1265: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);
1266: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);
1267: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L3_target);
1268: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L4_target);
1269: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L5_target);
1270: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_WT_target);
1271:
1272: /* Check for territories for this Usage/Transaction Type */
1273: /* This check is not done in date effective mode as inactive territories */

Line 1270: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_WT_target);

1266: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);
1267: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L3_target);
1268: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L4_target);
1269: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L5_target);
1270: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_WT_target);
1271:
1272: /* Check for territories for this Usage/Transaction Type */
1273: /* This check is not done in date effective mode as inactive territories */
1274: /* can also win depending on the date of the transaction object */

Line 1354: 'Call to JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns API begins for : ' || l_trans_target);

1350:
1351: -- debug message
1352: jty_log(FND_LOG.LEVEL_STATEMENT,
1353: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.decompose_terr_defns',
1354: 'Call to JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns API begins for : ' || l_trans_target);
1355:
1356: JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns
1357: (p_Api_Version_Number => 1.0,
1358: p_Init_Msg_List => FND_API.G_FALSE,

Line 1356: JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns

1352: jty_log(FND_LOG.LEVEL_STATEMENT,
1353: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.decompose_terr_defns',
1354: 'Call to JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns API begins for : ' || l_trans_target);
1355:
1356: JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns
1357: (p_Api_Version_Number => 1.0,
1358: p_Init_Msg_List => FND_API.G_FALSE,
1359: p_trans_target => l_trans_target,
1360: p_classify_terr_comb => 'N',

Line 1375: 'JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns API has failed for ' || l_trans_target;

1371: retcode => RETCODE );
1372:
1373: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1374: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP: Call to ' ||
1375: 'JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns API has failed for ' || l_trans_target;
1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;
1378:
1379: -- debug message