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.CSI_PARTY_RELATIONSHIPS_PUB dependencies on DBMS_SQL

Line 123: l_get_party_cursor_id := dbms_sql.open_cursor;

119: -- Build the select statement
120: l_select_stmt := l_select_stmt || ' where '||l_where_clause;
121:
122: -- Open the cursor
123: l_get_party_cursor_id := dbms_sql.open_cursor;
124:
125: --Parse the select statement
126: dbms_sql.parse(l_get_party_cursor_id, l_select_stmt , dbms_sql.native);
127:

Line 126: dbms_sql.parse(l_get_party_cursor_id, l_select_stmt , dbms_sql.native);

122: -- Open the cursor
123: l_get_party_cursor_id := dbms_sql.open_cursor;
124:
125: --Parse the select statement
126: dbms_sql.parse(l_get_party_cursor_id, l_select_stmt , dbms_sql.native);
127:
128: -- Bind the variables
129: csi_party_relationships_pvt.Bind_pty_variable(p_party_query_rec, l_get_party_cursor_id);
130:

Line 135: l_rows_processed := dbms_sql.execute(l_get_party_cursor_id);

131: -- Define output variables
132: csi_party_relationships_pvt.Define_Pty_Columns(l_get_party_cursor_id);
133:
134: -- execute the select statement
135: l_rows_processed := dbms_sql.execute(l_get_party_cursor_id);
136:
137: LOOP
138: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_party_cursor_id) = 0;
139: -- get the values after executing the selecl statement

Line 138: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_party_cursor_id) = 0;

134: -- execute the select statement
135: l_rows_processed := dbms_sql.execute(l_get_party_cursor_id);
136:
137: LOOP
138: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_party_cursor_id) = 0;
139: -- get the values after executing the selecl statement
140: csi_party_relationships_pvt.Get_pty_Column_Values(l_get_party_cursor_id, l_party_rec);
141: l_count := l_count + 1;
142: x_party_header_tbl(l_count) := l_party_rec;

Line 146: DBMS_SQL.CLOSE_CURSOR(l_get_party_cursor_id);

142: x_party_header_tbl(l_count) := l_party_rec;
143: END LOOP;
144:
145: -- Close the cursor
146: DBMS_SQL.CLOSE_CURSOR(l_get_party_cursor_id);
147:
148: IF ((p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE)) THEN
149:
150: IF p_time_stamp <= sysdate THEN

Line 340: IF DBMS_SQL.IS_OPEN(l_get_party_cursor_id) THEN

336: FND_MSG_PUB.Count_And_Get
337: ( p_count => x_msg_count,
338: p_data => x_msg_data );
339: WHEN OTHERS THEN
340: IF DBMS_SQL.IS_OPEN(l_get_party_cursor_id) THEN
341: DBMS_SQL.CLOSE_CURSOR(l_get_party_cursor_id);
342: END IF;
343: -- ROLLBACK TO get_inst_party_rel_pub;
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 341: DBMS_SQL.CLOSE_CURSOR(l_get_party_cursor_id);

337: ( p_count => x_msg_count,
338: p_data => x_msg_data );
339: WHEN OTHERS THEN
340: IF DBMS_SQL.IS_OPEN(l_get_party_cursor_id) THEN
341: DBMS_SQL.CLOSE_CURSOR(l_get_party_cursor_id);
342: END IF;
343: -- ROLLBACK TO get_inst_party_rel_pub;
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
345: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2197: l_get_acct_cursor_id := dbms_sql.open_cursor;

2193: -- Build the select statement
2194: l_select_stmt := l_select_stmt || ' where '||l_where_clause;
2195:
2196: -- Open the cursor
2197: l_get_acct_cursor_id := dbms_sql.open_cursor;
2198:
2199: --Parse the select statement
2200: dbms_sql.parse(l_get_acct_cursor_id, l_select_stmt , dbms_sql.native);
2201:

Line 2200: dbms_sql.parse(l_get_acct_cursor_id, l_select_stmt , dbms_sql.native);

2196: -- Open the cursor
2197: l_get_acct_cursor_id := dbms_sql.open_cursor;
2198:
2199: --Parse the select statement
2200: dbms_sql.parse(l_get_acct_cursor_id, l_select_stmt , dbms_sql.native);
2201:
2202: -- Bind the variables
2203: csi_party_relationships_pvt.Bind_acct_variable(p_account_query_rec, l_get_acct_cursor_id);
2204:

Line 2209: l_rows_processed := dbms_sql.execute(l_get_acct_cursor_id);

2205: -- Define output variables
2206: csi_party_relationships_pvt.Define_Acct_Columns(l_get_acct_cursor_id);
2207:
2208: -- execute the select statement
2209: l_rows_processed := dbms_sql.execute(l_get_acct_cursor_id);
2210:
2211: LOOP
2212: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_acct_cursor_id) = 0;
2213: csi_party_relationships_pvt.Get_acct_Column_Values(l_get_acct_cursor_id, l_party_account_rec);

Line 2212: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_acct_cursor_id) = 0;

2208: -- execute the select statement
2209: l_rows_processed := dbms_sql.execute(l_get_acct_cursor_id);
2210:
2211: LOOP
2212: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_acct_cursor_id) = 0;
2213: csi_party_relationships_pvt.Get_acct_Column_Values(l_get_acct_cursor_id, l_party_account_rec);
2214: l_count := l_count + 1;
2215: x_account_header_tbl(l_count) := l_party_account_rec;
2216: END LOOP;

Line 2219: DBMS_SQL.CLOSE_CURSOR(l_get_acct_cursor_id);

2215: x_account_header_tbl(l_count) := l_party_account_rec;
2216: END LOOP;
2217:
2218: -- Close the cursor
2219: DBMS_SQL.CLOSE_CURSOR(l_get_acct_cursor_id);
2220:
2221: IF ((p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE)) THEN
2222: IF p_time_stamp <= sysdate THEN
2223: -- Contruct from the history if p_time_stamp is less than sysdate

Line 2278: IF dbms_sql.is_open(l_get_acct_cursor_id) then

2274: FND_MSG_PUB.Count_And_Get
2275: ( p_count => x_msg_count,
2276: p_data => x_msg_data );
2277: WHEN OTHERS THEN
2278: IF dbms_sql.is_open(l_get_acct_cursor_id) then
2279: dbms_sql.close_cursor(l_get_acct_cursor_id);
2280: END IF;
2281: -- ROLLBACK TO get_inst_party_acct_pub;
2282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2279: dbms_sql.close_cursor(l_get_acct_cursor_id);

2275: ( p_count => x_msg_count,
2276: p_data => x_msg_data );
2277: WHEN OTHERS THEN
2278: IF dbms_sql.is_open(l_get_acct_cursor_id) then
2279: dbms_sql.close_cursor(l_get_acct_cursor_id);
2280: END IF;
2281: -- ROLLBACK TO get_inst_party_acct_pub;
2282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2283: IF FND_MSG_PUB.Check_Msg_Level