DBA Data[Home] [Help]

APPS.JTY_ASSIGN_BULK_PUB dependencies on JTY_TAE_CONTROL_PVT

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

1342: ' WT table name : ' || l_WT_target);
1343: END IF;
1344:
1345: /* set NOLOGGING on JTF_TAE_..._MATCHES and JTF_TAE_..._WINNERS tables */
1346: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);
1347: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_match_target);
1348: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_umatch_target);
1349: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winner_target);
1350: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);

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

1343: END IF;
1344:
1345: /* set NOLOGGING on JTF_TAE_..._MATCHES and JTF_TAE_..._WINNERS tables */
1346: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);
1347: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_match_target);
1348: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_umatch_target);
1349: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winner_target);
1350: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);
1351: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);

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

1344:
1345: /* set NOLOGGING on JTF_TAE_..._MATCHES and JTF_TAE_..._WINNERS tables */
1346: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);
1347: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_match_target);
1348: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_umatch_target);
1349: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winner_target);
1350: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);
1351: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);
1352: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);

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

1345: /* set NOLOGGING on JTF_TAE_..._MATCHES and JTF_TAE_..._WINNERS tables */
1346: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);
1347: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_match_target);
1348: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_umatch_target);
1349: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winner_target);
1350: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);
1351: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);
1352: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);
1353: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L3_target);

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

1346: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);
1347: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_match_target);
1348: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_umatch_target);
1349: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winner_target);
1350: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);
1351: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);
1352: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);
1353: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L3_target);
1354: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L4_target);

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

1347: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_match_target);
1348: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_umatch_target);
1349: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winner_target);
1350: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);
1351: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);
1352: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);
1353: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L3_target);
1354: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L4_target);
1355: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L5_target);

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

1348: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_umatch_target);
1349: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winner_target);
1350: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);
1351: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);
1352: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);
1353: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L3_target);
1354: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L4_target);
1355: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L5_target);
1356: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_WT_target);

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

1349: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winner_target);
1350: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);
1351: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);
1352: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);
1353: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L3_target);
1354: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L4_target);
1355: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L5_target);
1356: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_WT_target);
1357:

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

1350: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_uwinner_target);
1351: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);
1352: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);
1353: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L3_target);
1354: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L4_target);
1355: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L5_target);
1356: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_WT_target);
1357:
1358: /* Check for territories for this Usage/Transaction Type */

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

1351: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L1_target);
1352: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);
1353: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L3_target);
1354: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L4_target);
1355: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L5_target);
1356: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_WT_target);
1357:
1358: /* Check for territories for this Usage/Transaction Type */
1359: /* This check is not done in date effective mode as inactive territories */

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

1352: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L2_target);
1353: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L3_target);
1354: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L4_target);
1355: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_L5_target);
1356: JTY_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_WT_target);
1357:
1358: /* Check for territories for this Usage/Transaction Type */
1359: /* This check is not done in date effective mode as inactive territories */
1360: /* can also win depending on the date of the transaction object */

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

1443: -- debug message
1444: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1445: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1446: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.decompose_terr_defns',
1447: 'Call to JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns API begins for : ' || l_trans_target);
1448: END IF;
1449:
1450: JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns
1451: (p_Api_Version_Number => 1.0,

Line 1450: JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns

1446: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.decompose_terr_defns',
1447: 'Call to JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns API begins for : ' || l_trans_target);
1448: END IF;
1449:
1450: JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns
1451: (p_Api_Version_Number => 1.0,
1452: p_Init_Msg_List => FND_API.G_FALSE,
1453: p_trans_target => l_trans_target,
1454: p_classify_terr_comb => 'N',

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

1465: retcode => RETCODE );
1466:
1467: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1468: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP: Call to ' ||
1469: 'JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns API has failed for ' || l_trans_target;
1470: RAISE FND_API.G_EXC_ERROR;
1471: END IF;
1472:
1473: -- debug message