[Home] [Help]
60: -- x_rows_processed: rows processed - useful for the ad parallel upgrade
61: --End of Comments
62: --------------------------------------------------------------------------------
63: PROCEDURE process_modified_po_lines(p_batch_size IN NUMBER default 2500,
64: p_base_lang IN FND_LANGUAGES.language_code%TYPE default null,
65: p_start_id IN NUMBER default null,
66: p_end_id IN NUMBER default null,
67: x_return_status IN OUT NOCOPY VARCHAR,
68: x_rows_processed IN OUT NOCOPY NUMBER)
352: -- x_rows_processed: rows processed - useful for the ad parallel upgrade
353: --End of Comments
354: --------------------------------------------------------------------------------
355: PROCEDURE process_new_po_lines( p_batch_size IN NUMBER default 2500,
356: p_base_lang IN FND_LANGUAGES.language_code%TYPE default null,
357: p_start_id IN NUMBER default null,
358: p_end_id IN NUMBER default null,
359: x_return_status IN OUT NOCOPY VARCHAR,
360: x_rows_processed IN OUT NOCOPY NUMBER)
504: -- None
505: --End of Comments
506: --------------------------------------------------------------------------------
507: PROCEDURE create_line_attributes(p_batch_size IN NUMBER,
508: p_base_lang IN FND_LANGUAGES.language_code%TYPE)
509: IS
510: l_api_name CONSTANT VARCHAR2(30) := 'create_line_attributes';
511: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
512: l_progress VARCHAR2(3) := '000';
608: -- None
609: --End of Comments
610: --------------------------------------------------------------------------------
611: PROCEDURE create_line_attributes_tlp(p_batch_size IN NUMBER,
612: p_base_lang IN FND_LANGUAGES.language_code%TYPE)
613: IS
614: l_api_name CONSTANT VARCHAR2(30) := 'create_line_attributes_tlp';
615: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
616: l_progress VARCHAR2(3) := '000';
838: -- None
839: --End of Comments
840: --------------------------------------------------------------------------------
841: PROCEDURE process_modified_rt_lines(p_batch_size IN NUMBER,
842: p_base_lang IN FND_LANGUAGES.language_code%TYPE)
843: IS
844: -- SQL What: Cursor to get modified RT lines
845: -- Whether to recreate the attribute/TLP record is based on
846: -- what has changed - recreate only if iP_category_id/description/
1125: -- None
1126: --End of Comments
1127: --------------------------------------------------------------------------------
1128: PROCEDURE process_new_rt_lines(p_batch_size IN NUMBER,
1129: p_base_lang IN FND_LANGUAGES.language_code%TYPE)
1130: IS
1131: -- SQL What: Cursor to get RT lines that have not been upgraded
1132: -- SQL Why : To update the attributes
1133: -- SQL Join: last_updated_program