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_OPPTY dependencies on JTF_TERR_NUMBER_LIST

Line 88: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_LEAD_ID);

84: AND ACC.request_id IS NULL );
85:
86: ELSE
87: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_START);
88: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_LEAD_ID);
89: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
90: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
91: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
92: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);

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

85:
86: ELSE
87: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_START);
88: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_LEAD_ID);
89: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
90: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
91: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
92: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
93: l_trans_rec.txn_date := jtf_terr_date_list(null);

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

86: ELSE
87: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_START);
88: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_LEAD_ID);
89: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
90: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
91: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
92: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
93: l_trans_rec.txn_date := jtf_terr_date_list(null);
94: JTY_ASSIGN_REALTIME_PUB.get_winners(

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

87: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_START);
88: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_LEAD_ID);
89: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
90: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
91: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
92: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
93: l_trans_rec.txn_date := jtf_terr_date_list(null);
94: JTY_ASSIGN_REALTIME_PUB.get_winners(
95: p_api_version_number => 1.0,

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

88: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_LEAD_ID);
89: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
90: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
91: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
92: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
93: l_trans_rec.txn_date := jtf_terr_date_list(null);
94: JTY_ASSIGN_REALTIME_PUB.get_winners(
95: p_api_version_number => 1.0,
96: p_init_msg_list => FND_API.G_FALSE,

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

827: WHERE lead_id = G_LEAD_ID
828: AND NVL(freeze_flag, 'N') <> 'Y'
829: AND SALESFORCE_ID||SALES_GROUP_ID NOT IN (
830: SELECT RESTAB.RES||GRPTAB.GRP FROM
831: (SELECT rownum ROW_NUM,A.COLUMN_VALUE RES FROM TABLE(CAST(p_WinningTerrMember_tbl.resource_id AS jtf_terr_number_list)) a) RESTAB,
832: (SELECT rownum ROW_NUM,b.COLUMN_VALUE GRP FROM TABLE(CAST(p_WinningTerrMember_tbl.group_id AS jtf_terr_number_list)) b) GRPTAB
833: WHERE RESTAB.ROW_NUM = GRPTAB.ROW_NUM
834: )
835: AND NOT EXISTS (SELECT 'X'

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

828: AND NVL(freeze_flag, 'N') <> 'Y'
829: AND SALESFORCE_ID||SALES_GROUP_ID NOT IN (
830: SELECT RESTAB.RES||GRPTAB.GRP FROM
831: (SELECT rownum ROW_NUM,A.COLUMN_VALUE RES FROM TABLE(CAST(p_WinningTerrMember_tbl.resource_id AS jtf_terr_number_list)) a) RESTAB,
832: (SELECT rownum ROW_NUM,b.COLUMN_VALUE GRP FROM TABLE(CAST(p_WinningTerrMember_tbl.group_id AS jtf_terr_number_list)) b) GRPTAB
833: WHERE RESTAB.ROW_NUM = GRPTAB.ROW_NUM
834: )
835: AND NOT EXISTS (SELECT 'X'
836: FROM AS_SALES_CREDITS