APPS.AMS_PARTY_SEG_LOADER_PVT dependencies on JTF_NUMBER_TABLE

Line 31: x_party_tab OUT NOCOPY jtf_number_table,

27:
28: PROCEDURE Get_Party_Tab
29: (
30: p_cell_id IN NUMBER,
31: x_party_tab OUT NOCOPY jtf_number_table,
32: x_party_count OUT NOCOPY NUMBER,
33: x_return_status OUT NOCOPY VARCHAR2,
34: x_msg_count OUT NOCOPY NUMBER,
35: x_msg_data OUT NOCOPY VARCHAR2

Line 47: l_party_tab jtf_number_table := jtf_number_table();

43: l_temp NUMBER ;
44: l_party_cur NUMBER ;
45: l_dummy NUMBER ;
46: l_count NUMBER ;
47: l_party_tab jtf_number_table := jtf_number_table();
48: l_party_count NUMBER;
49:
50: BEGIN
51: IF (AMS_DEBUG_HIGH_ON) THEN

Line 160: , p_party_tbl IN jtf_number_table

156:
157: PROCEDURE Expire_Inactive_Party_Dbms
158: (
159: p_mkt_seg_id IN NUMBER
160: , p_party_tbl IN jtf_number_table
161: , x_return_status OUT NOCOPY VARCHAR2
162: , x_msg_count OUT NOCOPY NUMBER
163: , x_msg_data OUT NOCOPY VARCHAR2
164: )

Line 169: l_party_tbl jtf_number_table;

165: IS
166: l_api_name CONSTANT VARCHAR2(30) := 'expire_inactive_party_dbms';
167: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
168:
169: l_party_tbl jtf_number_table;
170:
171: TYPE num_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
172: l_exp_party_tbl num_tab;
173:

Line 180: SELECT column_value party_id FROM TABLE(CAST(p_party_tbl AS jtf_number_table));

176: SELECT party_id FROM AMS_PARTY_MARKET_SEGMENTS
177: WHERE market_segment_id = p_mkt_seg_id
178: AND end_date_active IS NULL
179: MINUS
180: SELECT column_value party_id FROM TABLE(CAST(p_party_tbl AS jtf_number_table));
181:
182: BEGIN
183:
184: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 371: , p_party_tbl IN jtf_number_table

367: -------------------------------------------------------------------------------
368: PROCEDURE Insert_New_Party_Dbms
369: (
370: p_mkt_seg_id IN NUMBER
371: , p_party_tbl IN jtf_number_table
372: , x_return_status OUT NOCOPY VARCHAR2
373: , x_msg_count OUT NOCOPY NUMBER
374: , x_msg_data OUT NOCOPY VARCHAR2
375: )

Line 384: SELECT column_value party_id FROM TABLE(CAST(p_party_tbl AS jtf_number_table))

380: l_party_tbl num_tab;
381:
382: --Cursor to select new parties which only available in with the seg query, not in segments table
383: CURSOR C_new_parties IS
384: SELECT column_value party_id FROM TABLE(CAST(p_party_tbl AS jtf_number_table))
385: MINUS
386: SELECT party_id FROM AMS_PARTY_MARKET_SEGMENTS
387: WHERE market_segment_id = p_mkt_seg_id;
388:

Line 392: (SELECT column_value party_id FROM TABLE(CAST(p_party_tbl AS jtf_number_table))) tbl

388:
389: --Cursor to select inactive parties from segments table which are also returned by seg query
390: CURSOR C_activate_parties IS
391: SELECT seg.party_id FROM AMS_PARTY_MARKET_SEGMENTS seg,
392: (SELECT column_value party_id FROM TABLE(CAST(p_party_tbl AS jtf_number_table))) tbl
393: WHERE seg.party_id = tbl.party_id
394: AND seg.end_date_active IS NOT NULL; --Inactive parties
395:
396: BEGIN

Line 537: l_party_tab jtf_number_table ;

533:
534: l_cell_id NUMBER := p_cell_id;
535: l_cell_name VARCHAR2 (120);
536: -- Define the table type to store the party ids
537: l_party_tab jtf_number_table ;
538: l_party_count NUMBER;
539: l_last_size NUMBER;
540:
541: CURSOR c_last_size (p_cell_id IN number)