eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_TP_TEMPLATES_PVT dependencies on CS_TP_TEMPLATES_PVT

Line 1: package body CS_TP_TEMPLATES_PVT as

1: package body CS_TP_TEMPLATES_PVT as
2: /* $Header: cstptmmb.pls 120.0 2005/06/01 10:55:21 appldev noship $ */
3:
4: /*============================================================================+
5: | Copyright (c) 1999 Oracle Corporation |

Line 2095: l_template_general_info CS_TP_TEMPLATES_PVT.Template ;

2091: l_init_msg_list_true VARCHAR2(20) := FND_API.G_TRUE;
2092: l_init_msg_list_false VARCHAR2(20) := FND_API.G_FALSE;
2093: l_init_commit_true VARCHAR2(20) := FND_API.G_FALSE; --//false
2094: l_init_commit_false VARCHAR2(20) := FND_API.G_FALSE;
2095: l_template_general_info CS_TP_TEMPLATES_PVT.Template ;
2096: l_template_attr_namepairs CS_TP_TEMPLATES_PVT.ID_NAME_PAIRS;
2097: l_template_attr_namepair CS_TP_TEMPLATES_PVT.ID_NAME_PAIR;
2098: l_temp_counter NUMBER := 0;
2099: l_template_link_list CS_TP_TEMPLATES_PVT.Template_Link_List;

Line 2096: l_template_attr_namepairs CS_TP_TEMPLATES_PVT.ID_NAME_PAIRS;

2092: l_init_msg_list_false VARCHAR2(20) := FND_API.G_FALSE;
2093: l_init_commit_true VARCHAR2(20) := FND_API.G_FALSE; --//false
2094: l_init_commit_false VARCHAR2(20) := FND_API.G_FALSE;
2095: l_template_general_info CS_TP_TEMPLATES_PVT.Template ;
2096: l_template_attr_namepairs CS_TP_TEMPLATES_PVT.ID_NAME_PAIRS;
2097: l_template_attr_namepair CS_TP_TEMPLATES_PVT.ID_NAME_PAIR;
2098: l_temp_counter NUMBER := 0;
2099: l_template_link_list CS_TP_TEMPLATES_PVT.Template_Link_List;
2100: l_medium_templink_list CS_TP_TEMPLATES_PVT.Template_Link_List;

Line 2097: l_template_attr_namepair CS_TP_TEMPLATES_PVT.ID_NAME_PAIR;

2093: l_init_commit_true VARCHAR2(20) := FND_API.G_FALSE; --//false
2094: l_init_commit_false VARCHAR2(20) := FND_API.G_FALSE;
2095: l_template_general_info CS_TP_TEMPLATES_PVT.Template ;
2096: l_template_attr_namepairs CS_TP_TEMPLATES_PVT.ID_NAME_PAIRS;
2097: l_template_attr_namepair CS_TP_TEMPLATES_PVT.ID_NAME_PAIR;
2098: l_temp_counter NUMBER := 0;
2099: l_template_link_list CS_TP_TEMPLATES_PVT.Template_Link_List;
2100: l_medium_templink_list CS_TP_TEMPLATES_PVT.Template_Link_List;
2101: l_template_attribute_list CS_TP_TEMPLATES_PVT.Template_Attribute_list;

Line 2099: l_template_link_list CS_TP_TEMPLATES_PVT.Template_Link_List;

2095: l_template_general_info CS_TP_TEMPLATES_PVT.Template ;
2096: l_template_attr_namepairs CS_TP_TEMPLATES_PVT.ID_NAME_PAIRS;
2097: l_template_attr_namepair CS_TP_TEMPLATES_PVT.ID_NAME_PAIR;
2098: l_temp_counter NUMBER := 0;
2099: l_template_link_list CS_TP_TEMPLATES_PVT.Template_Link_List;
2100: l_medium_templink_list CS_TP_TEMPLATES_PVT.Template_Link_List;
2101: l_template_attribute_list CS_TP_TEMPLATES_PVT.Template_Attribute_list;
2102: l_template_attribute CS_TP_TEMPLATES_PVT.Template_Attribute;
2103: l_template_question_list CS_TP_QUESTIONS_PVT.Question_List;

Line 2100: l_medium_templink_list CS_TP_TEMPLATES_PVT.Template_Link_List;

2096: l_template_attr_namepairs CS_TP_TEMPLATES_PVT.ID_NAME_PAIRS;
2097: l_template_attr_namepair CS_TP_TEMPLATES_PVT.ID_NAME_PAIR;
2098: l_temp_counter NUMBER := 0;
2099: l_template_link_list CS_TP_TEMPLATES_PVT.Template_Link_List;
2100: l_medium_templink_list CS_TP_TEMPLATES_PVT.Template_Link_List;
2101: l_template_attribute_list CS_TP_TEMPLATES_PVT.Template_Attribute_list;
2102: l_template_attribute CS_TP_TEMPLATES_PVT.Template_Attribute;
2103: l_template_question_list CS_TP_QUESTIONS_PVT.Question_List;
2104: l_template_question_number NUMBER;

Line 2101: l_template_attribute_list CS_TP_TEMPLATES_PVT.Template_Attribute_list;

2097: l_template_attr_namepair CS_TP_TEMPLATES_PVT.ID_NAME_PAIR;
2098: l_temp_counter NUMBER := 0;
2099: l_template_link_list CS_TP_TEMPLATES_PVT.Template_Link_List;
2100: l_medium_templink_list CS_TP_TEMPLATES_PVT.Template_Link_List;
2101: l_template_attribute_list CS_TP_TEMPLATES_PVT.Template_Attribute_list;
2102: l_template_attribute CS_TP_TEMPLATES_PVT.Template_Attribute;
2103: l_template_question_list CS_TP_QUESTIONS_PVT.Question_List;
2104: l_template_question_number NUMBER;
2105: l_templ_ques_retriv_num NUMBER;

Line 2102: l_template_attribute CS_TP_TEMPLATES_PVT.Template_Attribute;

2098: l_temp_counter NUMBER := 0;
2099: l_template_link_list CS_TP_TEMPLATES_PVT.Template_Link_List;
2100: l_medium_templink_list CS_TP_TEMPLATES_PVT.Template_Link_List;
2101: l_template_attribute_list CS_TP_TEMPLATES_PVT.Template_Attribute_list;
2102: l_template_attribute CS_TP_TEMPLATES_PVT.Template_Attribute;
2103: l_template_question_list CS_TP_QUESTIONS_PVT.Question_List;
2104: l_template_question_number NUMBER;
2105: l_templ_ques_retriv_num NUMBER;
2106: l_template_question CS_TP_QUESTIONS_PVT.Question;

Line 2121: CS_TP_TEMPLATES_PVT.Show_Template(

2117: begin
2118: X_Template_ID := 0;
2119:
2120: --/** a)Query the general information by the old given template ID
2121: CS_TP_TEMPLATES_PVT.Show_Template(
2122: p_api_version_number => p_api_version_number,
2123: p_init_msg_list => l_init_msg_list_true,
2124: p_commit => l_init_commit_true,
2125: P_Template_ID => B_Template_ID,

Line 2136: CS_TP_TEMPLATES_PVT.Add_Template(p_api_version_number => p_api_version_number,

2132: --/** b) Generate one new template ID by these general information
2133: l_template_general_info.mTemplateName := X_Template_Name;
2134: l_template_general_info.mDefaultFlag := FND_API.G_FALSE;
2135:
2136: CS_TP_TEMPLATES_PVT.Add_Template(p_api_version_number => p_api_version_number,
2137: p_init_msg_list => l_init_msg_list_true,
2138: p_commit => l_init_commit_true,
2139: P_One_Template => l_template_general_info,
2140: X_Msg_Count => X_Msg_Count,

Line 2147: CS_TP_TEMPLATES_PVT.Show_Link_Attribute_List (

2143: X_Template_ID => X_Template_ID);
2144:
2145: --/** c) Query the template link information
2146: --/** c1) First need to query all the attributes lists codes
2147: CS_TP_TEMPLATES_PVT.Show_Link_Attribute_List (
2148: p_api_version_number => p_api_version_number,
2149: p_init_msg_list => l_init_msg_list_true,
2150: p_commit => l_init_commit_true,
2151: P_Identify => CS_TP_TEMPLATES_PVT.G_JTF_LINK,

Line 2151: P_Identify => CS_TP_TEMPLATES_PVT.G_JTF_LINK,

2147: CS_TP_TEMPLATES_PVT.Show_Link_Attribute_List (
2148: p_api_version_number => p_api_version_number,
2149: p_init_msg_list => l_init_msg_list_true,
2150: p_commit => l_init_commit_true,
2151: P_Identify => CS_TP_TEMPLATES_PVT.G_JTF_LINK,
2152: X_Msg_Count => X_Msg_Count,
2153: X_Msg_Data => X_Msg_Data,
2154: X_Return_Status => X_Return_Status,
2155: X_IDName_Pairs => l_template_attr_namepairs);

Line 2165: CS_TP_TEMPLATES_PVT.Show_Template_Links(

2161: l_template_attr_namepairs(l_temp_counter).mOBJECT_CODE;
2162: l_template_attr_namepair.mNAME :=
2163: l_template_attr_namepairs(l_temp_counter).mNAME;
2164: --/** query the attr links
2165: CS_TP_TEMPLATES_PVT.Show_Template_Links(
2166: p_api_version_number => p_api_version_number,
2167: p_init_msg_list => l_init_msg_list_true,
2168: p_commit => l_init_commit_true,
2169: P_Template_ID => B_Template_ID,

Line 2183: CS_TP_TEMPLATES_PVT.Update_Template_Links (

2179: End Loop;
2180: End If;
2181: --dbms_output.put_line(' I am here four' );
2182:
2183: CS_TP_TEMPLATES_PVT.Update_Template_Links (
2184: p_api_version_number => p_api_version_number,
2185: p_init_msg_list => l_init_msg_list_true,
2186: p_commit => l_init_commit_true ,
2187: P_Template_ID => X_Template_ID,

Line 2202: CS_TP_TEMPLATES_PVT.Show_Link_Attribute_List (

2198:
2199:
2200: --/** e) Query the template threshvalue information
2201: --/** e1) Query the attribute lists
2202: CS_TP_TEMPLATES_PVT.Show_Link_Attribute_List (
2203: p_api_version_number => p_api_version_number,
2204: p_init_msg_list => l_init_msg_list_true,
2205: p_commit => l_init_commit_true,
2206: P_Identify => CS_TP_TEMPLATES_PVT.G_JTF_ATTRIBUTE,

Line 2206: P_Identify => CS_TP_TEMPLATES_PVT.G_JTF_ATTRIBUTE,

2202: CS_TP_TEMPLATES_PVT.Show_Link_Attribute_List (
2203: p_api_version_number => p_api_version_number,
2204: p_init_msg_list => l_init_msg_list_true,
2205: p_commit => l_init_commit_true,
2206: P_Identify => CS_TP_TEMPLATES_PVT.G_JTF_ATTRIBUTE,
2207: X_Msg_Count => X_Msg_Count,
2208: X_Msg_Data => X_Msg_Data,
2209: X_Return_Status => X_Return_Status,
2210: X_IDName_Pairs => l_template_attr_namepairs);

Line 2222: CS_TP_TEMPLATES_PVT.Show_Template_Attributes(

2218: l_template_attr_namepair.mNAME :=
2219: l_template_attr_namepairs(l_temp_counter).mNAME;
2220:
2221: --/** first query the old template value
2222: CS_TP_TEMPLATES_PVT.Show_Template_Attributes(
2223: p_api_version_number => p_api_version_number,
2224: p_init_msg_list => l_init_msg_list_true,
2225: p_commit => l_init_commit_true,
2226: P_Template_ID => B_Template_ID,

Line 2240: CS_TP_TEMPLATES_PVT.Update_Template_Attributes (

2236: l_template_attribute_list(i).mAttributeID := NULL;
2237: End Loop;
2238: End If;
2239: --/** update the new template value
2240: CS_TP_TEMPLATES_PVT.Update_Template_Attributes (
2241: p_api_version_number => p_api_version_number,
2242: p_init_msg_list => l_init_msg_list_true,
2243: p_commit => l_init_commit_true,
2244: P_Template_ID => X_Template_ID,

Line 2404: g_pkg_pkg_name CONSTANT VARCHAR2(30) := 'CS_TP_TEMPLATES_PVT';

2400: B_Obsolete OUT NOCOPY VARCHAR2)
2401:
2402: IS
2403: l_api_name CONSTANT VARCHAR2(30) := 'test_template_obsolete';
2404: g_pkg_pkg_name CONSTANT VARCHAR2(30) := 'CS_TP_TEMPLATES_PVT';
2405: l_current_date DATE := sysdate;
2406: l_temp_date_format VARCHAR2(100); --//*:= get_calender_date_format;
2407: l_date_format VARCHAR2(100):= get_calender_date_format; --//** temp use
2408: l_template_general_info CS_TP_TEMPLATES_PVT.Template ;

Line 2408: l_template_general_info CS_TP_TEMPLATES_PVT.Template ;

2404: g_pkg_pkg_name CONSTANT VARCHAR2(30) := 'CS_TP_TEMPLATES_PVT';
2405: l_current_date DATE := sysdate;
2406: l_temp_date_format VARCHAR2(100); --//*:= get_calender_date_format;
2407: l_date_format VARCHAR2(100):= get_calender_date_format; --//** temp use
2408: l_template_general_info CS_TP_TEMPLATES_PVT.Template ;
2409: BEGIN
2410: l_temp_date_format := get_calender_date_format;
2411: CS_TP_TEMPLATES_PVT.Show_Template(
2412: p_api_version_number => p_api_version_number,

Line 2411: CS_TP_TEMPLATES_PVT.Show_Template(

2407: l_date_format VARCHAR2(100):= get_calender_date_format; --//** temp use
2408: l_template_general_info CS_TP_TEMPLATES_PVT.Template ;
2409: BEGIN
2410: l_temp_date_format := get_calender_date_format;
2411: CS_TP_TEMPLATES_PVT.Show_Template(
2412: p_api_version_number => p_api_version_number,
2413: p_init_msg_list => p_init_msg_list,
2414: p_commit => p_commit,
2415: P_Template_ID => B_Template_ID,

Line 3286: END CS_TP_TEMPLATES_PVT;

3282: p_data => x_msg_data);
3283: END Add_Template_Links;
3284:
3285:
3286: END CS_TP_TEMPLATES_PVT;