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.CCT_DEFAULT_LOOKUP_PUB dependencies on CCT_COLLECTION_UTIL_PUB

Line 50: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_party_id_Key,p_result);

46: -- Check if Customer_ID is already present in incoming request. If yes call getPartyForObject
47: -- and retrieve CustomerName for that ID. If no CustomerName can be found then re-try using
48: -- above KEYs.
49:
50: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_party_id_Key,p_result);
51: if(p_result='Y') then
52: p_object_type:=p_cct_party_id_Key;
53: AST_ROUTING_PUB.getPartyForObject(p_object_type,p_object_value,p_party_name,p_party_id);
54: If ((p_party_id<>AST_ROUTING_PUB.G_NO_PARTY) AND (p_party_id<>AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN

Line 55: p_tmp_result:=CCT_collection_util_pub.put(x_key_value_varr,p_cct_party_name_key,p_party_name);

51: if(p_result='Y') then
52: p_object_type:=p_cct_party_id_Key;
53: AST_ROUTING_PUB.getPartyForObject(p_object_type,p_object_value,p_party_name,p_party_id);
54: If ((p_party_id<>AST_ROUTING_PUB.G_NO_PARTY) AND (p_party_id<>AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
55: p_tmp_result:=CCT_collection_util_pub.put(x_key_value_varr,p_cct_party_name_key,p_party_name);
56: p_result:='Y';
57: return p_result;
58: END IF;
59: --dbms_output.put_line('@Start : Value of key '||p_object_type||' and value '||p_object_value);

Line 63: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_1,p_result);

59: --dbms_output.put_line('@Start : Value of key '||p_object_type||' and value '||p_object_value);
60:
61: end if;
62:
63: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_1,p_result);
64: if(p_result='Y') then
65: p_object_type:=p_cct_object_type_1;
66: goto EXECUTE_API;
67: end if;

Line 68: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_2,p_result);

64: if(p_result='Y') then
65: p_object_type:=p_cct_object_type_1;
66: goto EXECUTE_API;
67: end if;
68: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_2,p_result);
69: if(p_result='Y') then
70: p_object_type:=p_cct_object_type_2;
71: goto EXECUTE_API;
72: end if;

Line 73: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_3,p_result);

69: if(p_result='Y') then
70: p_object_type:=p_cct_object_type_2;
71: goto EXECUTE_API;
72: end if;
73: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_3,p_result);
74: if(p_result='Y') then
75: p_object_type:=p_cct_object_type_3;
76: goto EXECUTE_API;
77: end if;

Line 78: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_4,p_result);

74: if(p_result='Y') then
75: p_object_type:=p_cct_object_type_3;
76: goto EXECUTE_API;
77: end if;
78: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_4,p_result);
79: if(p_result='Y') then
80: p_object_type:=p_cct_object_type_4;
81: goto EXECUTE_API;
82: end if;

Line 83: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_5,p_result);

79: if(p_result='Y') then
80: p_object_type:=p_cct_object_type_4;
81: goto EXECUTE_API;
82: end if;
83: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_5,p_result);
84: if(p_result='Y') then
85: p_object_type:=p_cct_object_type_5;
86: goto EXECUTE_API;
87: end if;

Line 88: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_6,p_result);

84: if(p_result='Y') then
85: p_object_type:=p_cct_object_type_5;
86: goto EXECUTE_API;
87: end if;
88: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_6,p_result);
89: if(p_result='Y') then
90: p_object_type:=p_cct_object_type_6;
91: goto EXECUTE_API;
92: end if;

Line 93: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_7,p_result);

89: if(p_result='Y') then
90: p_object_type:=p_cct_object_type_6;
91: goto EXECUTE_API;
92: end if;
93: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_7,p_result);
94: if(p_result='Y') then
95: p_object_type:=p_cct_object_type_7;
96: goto EXECUTE_API;
97: end if;

Line 98: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_8,p_result);

94: if(p_result='Y') then
95: p_object_type:=p_cct_object_type_7;
96: goto EXECUTE_API;
97: end if;
98: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_8,p_result);
99: if(p_result='Y') then
100: p_object_type:=p_cct_object_type_8;
101: goto EXECUTE_API;
102: end if;

Line 103: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_9,p_result);

99: if(p_result='Y') then
100: p_object_type:=p_cct_object_type_8;
101: goto EXECUTE_API;
102: end if;
103: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_9,p_result);
104: if(p_result='Y') then
105: p_object_type:=p_cct_object_type_9;
106: goto EXECUTE_API;
107: end if;

Line 108: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_10,p_result);

104: if(p_result='Y') then
105: p_object_type:=p_cct_object_type_9;
106: goto EXECUTE_API;
107: end if;
108: p_object_value:=cct_collection_util_pub.get(x_key_value_varr,p_cct_object_type_10,p_result);
109: if(p_result='Y') then
110: p_object_type:=p_cct_object_type_10;
111: goto EXECUTE_API;
112: end if;

Line 119: p_tmp_result:=CCT_collection_util_pub.put(x_key_value_varr,p_cct_party_id_key,to_char(p_party_id));

115:
116: <>
117: AST_ROUTING_PUB.getPartyForObject(p_object_type,p_object_value,p_party_name,p_party_id);
118: If ((p_party_id<>AST_ROUTING_PUB.G_NO_PARTY) AND (p_party_id<>AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
119: p_tmp_result:=CCT_collection_util_pub.put(x_key_value_varr,p_cct_party_id_key,to_char(p_party_id));
120: p_tmp_result:=CCT_collection_util_pub.put(x_key_value_varr,p_cct_party_name_key,p_party_name);
121: END IF;
122: --dbms_output.put_line('Value of key '||p_object_type||' and value '||p_object_value);
123: --dbms_output.put_line('Value of partyName '||p_party_name||' and p_party_id '||p_party_id);

Line 120: p_tmp_result:=CCT_collection_util_pub.put(x_key_value_varr,p_cct_party_name_key,p_party_name);

116: <>
117: AST_ROUTING_PUB.getPartyForObject(p_object_type,p_object_value,p_party_name,p_party_id);
118: If ((p_party_id<>AST_ROUTING_PUB.G_NO_PARTY) AND (p_party_id<>AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
119: p_tmp_result:=CCT_collection_util_pub.put(x_key_value_varr,p_cct_party_id_key,to_char(p_party_id));
120: p_tmp_result:=CCT_collection_util_pub.put(x_key_value_varr,p_cct_party_name_key,p_party_name);
121: END IF;
122: --dbms_output.put_line('Value of key '||p_object_type||' and value '||p_object_value);
123: --dbms_output.put_line('Value of partyName '||p_party_name||' and p_party_id '||p_party_id);
124: -- Everything succeeded, so mark the operation as success and return it