DBA Data[Home] [Help]

APPS.PRP_RTTAP_INT_PVT dependencies on JTF_TERR_NUMBER_LIST

Line 69: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_PROPOSAL_ID);

65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: IF NVL(FND_PROFILE.Value('PRP_ENABLE_ONLINE_TAP'), 'N') = 'Y' THEN
68:
69: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_PROPOSAL_ID);
70: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
71: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
72: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
73: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);

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

66:
67: IF NVL(FND_PROFILE.Value('PRP_ENABLE_ONLINE_TAP'), 'N') = 'Y' THEN
68:
69: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_PROPOSAL_ID);
70: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
71: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
72: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
73: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
74: l_trans_rec.txn_date := jtf_terr_date_list(null);

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

67: IF NVL(FND_PROFILE.Value('PRP_ENABLE_ONLINE_TAP'), 'N') = 'Y' THEN
68:
69: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_PROPOSAL_ID);
70: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
71: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
72: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
73: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
74: l_trans_rec.txn_date := jtf_terr_date_list(null);
75:

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

68:
69: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_PROPOSAL_ID);
70: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
71: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
72: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
73: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
74: l_trans_rec.txn_date := jtf_terr_date_list(null);
75:
76: -- Log Debug Messages.

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

69: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_PROPOSAL_ID);
70: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
71: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
72: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
73: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
74: l_trans_rec.txn_date := jtf_terr_date_list(null);
75:
76: -- Log Debug Messages.
77: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

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

717: WHERE proposal_id = G_PROPOSAL_ID
718: AND NVL(keep_flag, 'N') <> 'Y'
719: AND RESOURCE_ID||RESOURCE_GROUP_ID NOT IN (
720: SELECT RESTAB.RES||GRPTAB.GRP FROM
721: (SELECT rownum ROW_NUM,A.COLUMN_VALUE RES FROM TABLE(CAST(p_WinningTerrMember_tbl.resource_id AS jtf_terr_number_list)) a) RESTAB,
722: (SELECT rownum ROW_NUM,b.COLUMN_VALUE GRP FROM TABLE(CAST(p_WinningTerrMember_tbl.group_id AS jtf_terr_number_list)) b) GRPTAB
723: WHERE RESTAB.ROW_NUM = GRPTAB.ROW_NUM
724: );
725:

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

718: AND NVL(keep_flag, 'N') <> 'Y'
719: AND RESOURCE_ID||RESOURCE_GROUP_ID NOT IN (
720: SELECT RESTAB.RES||GRPTAB.GRP FROM
721: (SELECT rownum ROW_NUM,A.COLUMN_VALUE RES FROM TABLE(CAST(p_WinningTerrMember_tbl.resource_id AS jtf_terr_number_list)) a) RESTAB,
722: (SELECT rownum ROW_NUM,b.COLUMN_VALUE GRP FROM TABLE(CAST(p_WinningTerrMember_tbl.group_id AS jtf_terr_number_list)) b) GRPTAB
723: WHERE RESTAB.ROW_NUM = GRPTAB.ROW_NUM
724: );
725:
726: EXCEPTION