DBA Data[Home] [Help]

APPS.JTF_MINISITERUNTIME_PVT dependencies on JTF_NUMBER_TABLE

Line 292: p_msite_ids IN JTF_NUMBER_TABLE,

288: --+
289: PROCEDURE Load_Msite_List_Details
290: (
291: p_api_version IN NUMBER,
292: p_msite_ids IN JTF_NUMBER_TABLE,
293: x_msite_ids OUT JTF_NUMBER_TABLE,
294: x_master_msite_id OUT NUMBER,
295: x_minisite_cur OUT MINISITE_CUR_TYPE,
296: x_name_cur OUT NAME_CUR_TYPE,

Line 293: x_msite_ids OUT JTF_NUMBER_TABLE,

289: PROCEDURE Load_Msite_List_Details
290: (
291: p_api_version IN NUMBER,
292: p_msite_ids IN JTF_NUMBER_TABLE,
293: x_msite_ids OUT JTF_NUMBER_TABLE,
294: x_master_msite_id OUT NUMBER,
295: x_minisite_cur OUT MINISITE_CUR_TYPE,
296: x_name_cur OUT NAME_CUR_TYPE,
297: x_lang_cur OUT LANG_CUR_TYPE,

Line 301: x_section_msite_ids OUT JTF_NUMBER_TABLE,

297: x_lang_cur OUT LANG_CUR_TYPE,
298: x_currency_cur OUT CURRENCY_CUR_TYPE,
299: x_msite_resps_cur OUT MSITE_RESP_CUR_TYPE,
300: x_party_access_cur OUT MSITE_PRTY_ACCESS_CUR_TYPE,
301: x_section_msite_ids OUT JTF_NUMBER_TABLE,
302: x_section_ids OUT JTF_NUMBER_TABLE,
303: x_item_msite_ids OUT JTF_NUMBER_TABLE,
304: x_item_ids OUT JTF_NUMBER_TABLE,
305: x_return_status OUT VARCHAR2,

Line 302: x_section_ids OUT JTF_NUMBER_TABLE,

298: x_currency_cur OUT CURRENCY_CUR_TYPE,
299: x_msite_resps_cur OUT MSITE_RESP_CUR_TYPE,
300: x_party_access_cur OUT MSITE_PRTY_ACCESS_CUR_TYPE,
301: x_section_msite_ids OUT JTF_NUMBER_TABLE,
302: x_section_ids OUT JTF_NUMBER_TABLE,
303: x_item_msite_ids OUT JTF_NUMBER_TABLE,
304: x_item_ids OUT JTF_NUMBER_TABLE,
305: x_return_status OUT VARCHAR2,
306: x_msg_count OUT NUMBER,

Line 303: x_item_msite_ids OUT JTF_NUMBER_TABLE,

299: x_msite_resps_cur OUT MSITE_RESP_CUR_TYPE,
300: x_party_access_cur OUT MSITE_PRTY_ACCESS_CUR_TYPE,
301: x_section_msite_ids OUT JTF_NUMBER_TABLE,
302: x_section_ids OUT JTF_NUMBER_TABLE,
303: x_item_msite_ids OUT JTF_NUMBER_TABLE,
304: x_item_ids OUT JTF_NUMBER_TABLE,
305: x_return_status OUT VARCHAR2,
306: x_msg_count OUT NUMBER,
307: x_msg_data OUT VARCHAR2

Line 304: x_item_ids OUT JTF_NUMBER_TABLE,

300: x_party_access_cur OUT MSITE_PRTY_ACCESS_CUR_TYPE,
301: x_section_msite_ids OUT JTF_NUMBER_TABLE,
302: x_section_ids OUT JTF_NUMBER_TABLE,
303: x_item_msite_ids OUT JTF_NUMBER_TABLE,
304: x_item_ids OUT JTF_NUMBER_TABLE,
305: x_return_status OUT VARCHAR2,
306: x_msg_count OUT NUMBER,
307: x_msg_data OUT VARCHAR2
308: )

Line 404: x_msite_ids := JTF_NUMBER_TABLE();

400:
401: --+
402: -- If p_msite_ids is null, then load all the ids and put it in x_msite_ids
403: --+
404: x_msite_ids := JTF_NUMBER_TABLE();
405: IF (p_msite_ids IS NULL) THEN
406: l_index := 1;
407: FOR r3 IN c3 LOOP
408: x_msite_ids.EXTEND();

Line 514: x_section_msite_ids := JTF_NUMBER_TABLE();

510: l_exclude_flag := 'N';
511: END IF;
512:
513: -- Initialize the variables
514: x_section_msite_ids := JTF_NUMBER_TABLE();
515: x_section_ids := JTF_NUMBER_TABLE();
516: x_item_msite_ids := JTF_NUMBER_TABLE();
517: x_item_ids := JTF_NUMBER_TABLE();
518:

Line 515: x_section_ids := JTF_NUMBER_TABLE();

511: END IF;
512:
513: -- Initialize the variables
514: x_section_msite_ids := JTF_NUMBER_TABLE();
515: x_section_ids := JTF_NUMBER_TABLE();
516: x_item_msite_ids := JTF_NUMBER_TABLE();
517: x_item_ids := JTF_NUMBER_TABLE();
518:
519: IF (l_exclude_flag = 'Y') THEN

Line 516: x_item_msite_ids := JTF_NUMBER_TABLE();

512:
513: -- Initialize the variables
514: x_section_msite_ids := JTF_NUMBER_TABLE();
515: x_section_ids := JTF_NUMBER_TABLE();
516: x_item_msite_ids := JTF_NUMBER_TABLE();
517: x_item_ids := JTF_NUMBER_TABLE();
518:
519: IF (l_exclude_flag = 'Y') THEN
520:

Line 517: x_item_ids := JTF_NUMBER_TABLE();

513: -- Initialize the variables
514: x_section_msite_ids := JTF_NUMBER_TABLE();
515: x_section_ids := JTF_NUMBER_TABLE();
516: x_item_msite_ids := JTF_NUMBER_TABLE();
517: x_item_ids := JTF_NUMBER_TABLE();
518:
519: IF (l_exclude_flag = 'Y') THEN
520:
521: -- For sections