eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on JTF_TAE_1001_SC_WINNERS

Line 40: TYPE g_trans_object_id_tbl_type IS TABLE OF jtf_tae_1001_sc_winners.trans_object_id%TYPE;

36: TYPE g_rowid_tbl_type IS TABLE OF ROWID;
37:
38: TYPE g_comm_lines_api_id_tbl_type IS TABLE OF cn_comm_lines_api_all.comm_lines_api_id%TYPE;
39:
40: TYPE g_trans_object_id_tbl_type IS TABLE OF jtf_tae_1001_sc_winners.trans_object_id%TYPE;
41:
42: TYPE g_terr_id_tbl_type IS TABLE OF jtf_tae_1001_sc_winners.terr_id%TYPE;
43:
44: TYPE g_salesrep_id_tbl_type IS TABLE OF cn_salesreps.salesrep_id%TYPE;

Line 42: TYPE g_terr_id_tbl_type IS TABLE OF jtf_tae_1001_sc_winners.terr_id%TYPE;

38: TYPE g_comm_lines_api_id_tbl_type IS TABLE OF cn_comm_lines_api_all.comm_lines_api_id%TYPE;
39:
40: TYPE g_trans_object_id_tbl_type IS TABLE OF jtf_tae_1001_sc_winners.trans_object_id%TYPE;
41:
42: TYPE g_terr_id_tbl_type IS TABLE OF jtf_tae_1001_sc_winners.terr_id%TYPE;
43:
44: TYPE g_salesrep_id_tbl_type IS TABLE OF cn_salesreps.salesrep_id%TYPE;
45:
46: TYPE g_emp_no_tbl_type IS TABLE OF cn_salesreps.employee_number%TYPE;

Line 48: TYPE g_role_id_tbl_type IS TABLE OF jtf_tae_1001_sc_winners.role_id%TYPE;

44: TYPE g_salesrep_id_tbl_type IS TABLE OF cn_salesreps.salesrep_id%TYPE;
45:
46: TYPE g_emp_no_tbl_type IS TABLE OF cn_salesreps.employee_number%TYPE;
47:
48: TYPE g_role_id_tbl_type IS TABLE OF jtf_tae_1001_sc_winners.role_id%TYPE;
49:
50: TYPE g_split_pctg_tbl_type IS TABLE OF jtf_terr_rsc_all.attribute1%TYPE;
51:
52: TYPE g_rev_type_tbl_type IS TABLE OF jtf_terr_rsc_all.attribute1%TYPE;

Line 1103: from JTF_TAE_1001_SC_WINNERS A

1099: WHERE COMM_LINES_API_ID IN
1100: ( SELECT /*+ cardinality(a,1) */ TRANS_OBJECT_ID
1101: FROM (
1102: select /*+ no_merge */ DISTINCT TRANS_OBJECT_ID
1103: from JTF_TAE_1001_SC_WINNERS A
1104: where A.WORKER_ID = p_worker_id
1105: ) A
1106: WHERE EXISTS
1107: (

Line 1796: /* and populate the winning salesreps for each transaction in the table jtf_tae_1001_sc_winners */

1792: debugmsg('SCA : jty_assign_bulk_pub.collect_trans_data with oic_mode '||
1793: 'POST completed successfully');
1794: debugmsg('SCA : Populating data to WINNERS table');
1795: /* this api will apply the rules to the transactions present in jtf_tae_1001_sc_dea_trans */
1796: /* and populate the winning salesreps for each transaction in the table jtf_tae_1001_sc_winners */
1797: FOR l_worker_id IN 1..g_num_workers
1798: LOOP
1799:
1800: debugmsg('SCA : Submitting Child Request for worker id '|| l_worker_id

Line 1859: /* and populate the winning salesreps for each transaction in the table jtf_tae_1001_sc_winners */

1855: --Code added here to handle process_match and process_winners index stats
1856: -- in parallel
1857: debugmsg('SCA : Populating data to WINNERS table');
1858: /* this api will apply the rules to the transactions present in jtf_tae_1001_sc_dea_trans */
1859: /* and populate the winning salesreps for each transaction in the table jtf_tae_1001_sc_winners */
1860: FOR l_worker_id IN 1..g_num_workers
1861: LOOP
1862:
1863: debugmsg('SCA : Submitting Child Request for worker id '|| l_worker_id);

Line 1937: /* table jtf_tae_1001_sc_winners and create credited transactions in the table cn_comm_lines_api_all */

1933: errbuf := 'CN_SCATM_TAE_PUB.get_credited_txns.others';
1934: END get_credited_txns;
1935:
1936: /* This procedure gets the winning salesreps, split percentages and revenue types from the */
1937: /* table jtf_tae_1001_sc_winners and create credited transactions in the table cn_comm_lines_api_all */
1938: PROCEDURE process_new_txns(
1939: p_org_id IN NUMBER
1940: , p_worker_id IN NUMBER
1941: , errbuf IN OUT NOCOPY VARCHAR2

Line 1994: || 'FROM jtf_tae_1001_sc_winners a, '

1990: || ', '
1991: || ' b.'
1992: || l_ffname_rev_type
1993: || ' '
1994: || 'FROM jtf_tae_1001_sc_winners a, '
1995: || ' jtf_terr_rsc_all b, '
1996: || ' jtf_terr_all c, '
1997: || ' cn_salesreps d '
1998: || 'WHERE a.terr_rsc_id = b.terr_rsc_id '

Line 2582: /* table jtf_tae_1001_sc_winners and create credited transactions in the table cn_comm_lines_api_all */

2578: errbuf := 'CN_SCATM_TAE_PUB.handle_loaded_txns.others';
2579: END handle_loaded_txns;
2580:
2581: /* This procedure gets the winning salesreps, split percentages and revenue types from the */
2582: /* table jtf_tae_1001_sc_winners and create credited transactions in the table cn_comm_lines_api_all */
2583: PROCEDURE process_all_txns(
2584: p_org_id IN NUMBER
2585: , p_worker_id IN NUMBER
2586: , errbuf IN OUT NOCOPY VARCHAR2

Line 2733: || 'FROM jtf_tae_1001_sc_winners a, '

2729: || l_ffname_rev_type
2730: || ', '
2731: || ' ''N'', '
2732: || ' count(*) over(partition by d.comm_lines_api_id) '
2733: || 'FROM jtf_tae_1001_sc_winners a, '
2734: || ' jtf_terr_rsc_all b, '
2735: || ' jtf_terr_all c, '
2736: || ' cn_comm_lines_api_all d, '
2737: || ' cn_salesreps e '

Line 3512: /* and populate the winning salesreps for each transaction in the table jtf_tae_1001_sc_winners */

3508: /* Get the criterion to select transactions from api table */
3509: debugmsg('SCA : Populating data to WINNERS table for worker_id '||p_worker_id ||' and mode '||
3510: p_oic_mode);
3511: /* this api will apply the rules to the transactions present in jtf_tae_1001_sc_dea_trans */
3512: /* and populate the winning salesreps for each transaction in the table jtf_tae_1001_sc_winners */
3513:
3514: jty_assign_bulk_pub.get_winners(
3515: p_api_version_number => 1.0
3516: , p_init_msg_list => fnd_api.g_false