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.AS_RTTAP_ACCOUNT dependencies on JTF_TERR_NUMBER_LIST

Line 387: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_PARTY_ID);

383: ELSE
384: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_START);
385:
386:
387: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_PARTY_ID);
388: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
389: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
390: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
391: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);

Line 388: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);

384: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_START);
385:
386:
387: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_PARTY_ID);
388: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
389: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
390: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
391: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
392: l_trans_rec.txn_date := jtf_terr_date_list(null);

Line 389: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);

385:
386:
387: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_PARTY_ID);
388: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
389: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
390: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
391: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
392: l_trans_rec.txn_date := jtf_terr_date_list(null);
393: JTY_ASSIGN_REALTIME_PUB.get_winners(

Line 390: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);

386:
387: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_PARTY_ID);
388: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
389: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
390: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
391: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
392: l_trans_rec.txn_date := jtf_terr_date_list(null);
393: JTY_ASSIGN_REALTIME_PUB.get_winners(
394: p_api_version_number => 1.0,

Line 391: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);

387: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_PARTY_ID);
388: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
389: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
390: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
391: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
392: l_trans_rec.txn_date := jtf_terr_date_list(null);
393: JTY_ASSIGN_REALTIME_PUB.get_winners(
394: p_api_version_number => 1.0,
395: p_init_msg_list => FND_API.G_FALSE,

Line 1155: (SELECT rownum ROW_NUM,A.COLUMN_VALUE RES FROM TABLE(CAST(p_WinningTerrMember_tbl.resource_id AS jtf_terr_number_list)) a) RESTAB,

1151: AND sales_lead_id IS NULL
1152: AND NVL(freeze_flag, 'N') <> 'Y'
1153: AND SALESFORCE_ID||NVL(SALES_GROUP_ID,-777) NOT IN (
1154: SELECT RESTAB.RES||NVL(GRPTAB.GRP,-777) FROM
1155: (SELECT rownum ROW_NUM,A.COLUMN_VALUE RES FROM TABLE(CAST(p_WinningTerrMember_tbl.resource_id AS jtf_terr_number_list)) a) RESTAB,
1156: (SELECT rownum ROW_NUM,b.COLUMN_VALUE GRP FROM TABLE(CAST(p_WinningTerrMember_tbl.group_id AS jtf_terr_number_list)) b) GRPTAB
1157: WHERE RESTAB.ROW_NUM = GRPTAB.ROW_NUM
1158: ) ;
1159: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);

Line 1156: (SELECT rownum ROW_NUM,b.COLUMN_VALUE GRP FROM TABLE(CAST(p_WinningTerrMember_tbl.group_id AS jtf_terr_number_list)) b) GRPTAB

1152: AND NVL(freeze_flag, 'N') <> 'Y'
1153: AND SALESFORCE_ID||NVL(SALES_GROUP_ID,-777) NOT IN (
1154: SELECT RESTAB.RES||NVL(GRPTAB.GRP,-777) FROM
1155: (SELECT rownum ROW_NUM,A.COLUMN_VALUE RES FROM TABLE(CAST(p_WinningTerrMember_tbl.resource_id AS jtf_terr_number_list)) a) RESTAB,
1156: (SELECT rownum ROW_NUM,b.COLUMN_VALUE GRP FROM TABLE(CAST(p_WinningTerrMember_tbl.group_id AS jtf_terr_number_list)) b) GRPTAB
1157: WHERE RESTAB.ROW_NUM = GRPTAB.ROW_NUM
1158: ) ;
1159: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);
1160: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_END);