DBA Data[Home] [Help]

APPS.JTF_TERR_NAMEACC_PUB dependencies on JTF_TERR_NUMBER_LIST

Line 121: lp_trans_rec.trans_object_id1 := jtf_terr_number_list(p_party_id);

117: 'jtf.plsql.JTF_TERR_NAMEACC_PUB.Set_Winners_tbl.begin',
118: 'Initializing Input and Output records');
119: END IF;
120: -- Assign input parameters to lp_trans_Rec
121: lp_trans_rec.trans_object_id1 := jtf_terr_number_list(p_party_id);
122: IF p_party_site_id is not null
123: THEN
124: lp_trans_rec.trans_object_id2 := jtf_terr_number_list(p_party_site_id);
125: ELSE

Line 124: lp_trans_rec.trans_object_id2 := jtf_terr_number_list(p_party_site_id);

120: -- Assign input parameters to lp_trans_Rec
121: lp_trans_rec.trans_object_id1 := jtf_terr_number_list(p_party_id);
122: IF p_party_site_id is not null
123: THEN
124: lp_trans_rec.trans_object_id2 := jtf_terr_number_list(p_party_site_id);
125: ELSE
126: lp_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
127: END If;
128: lp_trans_rec.trans_object_id3 := jtf_terr_number_list(null);

Line 126: lp_trans_rec.trans_object_id2 := jtf_terr_number_list(null);

122: IF p_party_site_id is not null
123: THEN
124: lp_trans_rec.trans_object_id2 := jtf_terr_number_list(p_party_site_id);
125: ELSE
126: lp_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
127: END If;
128: lp_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
129: lp_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
130: lp_trans_rec.trans_object_id5 := jtf_terr_number_list(null);

Line 128: lp_trans_rec.trans_object_id3 := jtf_terr_number_list(null);

124: lp_trans_rec.trans_object_id2 := jtf_terr_number_list(p_party_site_id);
125: ELSE
126: lp_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
127: END If;
128: lp_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
129: lp_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
130: lp_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
131: IF p_asof_date is null
132: THEN

Line 129: lp_trans_rec.trans_object_id4 := jtf_terr_number_list(null);

125: ELSE
126: lp_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
127: END If;
128: lp_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
129: lp_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
130: lp_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
131: IF p_asof_date is null
132: THEN
133: lp_trans_rec.txn_date := jtf_terr_date_list(null);

Line 130: lp_trans_rec.trans_object_id5 := jtf_terr_number_list(null);

126: lp_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
127: END If;
128: lp_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
129: lp_trans_rec.trans_object_id4 := jtf_terr_number_list(null);
130: lp_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
131: IF p_asof_date is null
132: THEN
133: lp_trans_rec.txn_date := jtf_terr_date_list(null);
134: ELSE