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

Line 1450: l_handle := DBMS_SQL.open_cursor;

1446: -- Initialize API return status to success
1447: x_return_status := FND_API.G_RET_STS_SUCCESS;
1448: x_loading_status := 'CN_INSERTED';
1449: -- API body
1450: l_handle := DBMS_SQL.open_cursor;
1451: l_sql :=
1452: 'SELECT '||
1453: 'CCH.direct_salesrep_id,CCH.invoice_number,CCH.line_number, '||
1454: 'CCH.revenue_type,CCH.split_pct,RSD.employee_number, CCH.comm_lines_api_id, '||

Line 1583: DBMS_SQL.PARSE(l_handle,l_sql,DBMS_SQL.NATIVE);

1579: 'CCLA.comm_lines_api_id ';
1580: END IF;
1581: --insert into rao_debug values(l_sql);
1582: --commit;
1583: DBMS_SQL.PARSE(l_handle,l_sql,DBMS_SQL.NATIVE);
1584: IF (p_salesrep_id <> FND_API.G_MISS_NUM) THEN
1585: DBMS_SQL.BIND_VARIABLE(l_handle,'p_salesrep_id',p_salesrep_id);
1586: END IF;
1587: IF (p_pr_date_from <> FND_API.G_MISS_DATE) THEN

Line 1585: DBMS_SQL.BIND_VARIABLE(l_handle,'p_salesrep_id',p_salesrep_id);

1581: --insert into rao_debug values(l_sql);
1582: --commit;
1583: DBMS_SQL.PARSE(l_handle,l_sql,DBMS_SQL.NATIVE);
1584: IF (p_salesrep_id <> FND_API.G_MISS_NUM) THEN
1585: DBMS_SQL.BIND_VARIABLE(l_handle,'p_salesrep_id',p_salesrep_id);
1586: END IF;
1587: IF (p_pr_date_from <> FND_API.G_MISS_DATE) THEN
1588: DBMS_SQL.BIND_VARIABLE(l_handle,'p_pr_date_from',p_pr_date_from);
1589: END IF;

Line 1588: DBMS_SQL.BIND_VARIABLE(l_handle,'p_pr_date_from',p_pr_date_from);

1584: IF (p_salesrep_id <> FND_API.G_MISS_NUM) THEN
1585: DBMS_SQL.BIND_VARIABLE(l_handle,'p_salesrep_id',p_salesrep_id);
1586: END IF;
1587: IF (p_pr_date_from <> FND_API.G_MISS_DATE) THEN
1588: DBMS_SQL.BIND_VARIABLE(l_handle,'p_pr_date_from',p_pr_date_from);
1589: END IF;
1590: IF (p_pr_date_to <> FND_API.G_MISS_DATE) THEN
1591: DBMS_SQL.BIND_VARIABLE(l_handle,'p_pr_date_to',p_pr_date_to);
1592: END IF;

Line 1591: DBMS_SQL.BIND_VARIABLE(l_handle,'p_pr_date_to',p_pr_date_to);

1587: IF (p_pr_date_from <> FND_API.G_MISS_DATE) THEN
1588: DBMS_SQL.BIND_VARIABLE(l_handle,'p_pr_date_from',p_pr_date_from);
1589: END IF;
1590: IF (p_pr_date_to <> FND_API.G_MISS_DATE) THEN
1591: DBMS_SQL.BIND_VARIABLE(l_handle,'p_pr_date_to',p_pr_date_to);
1592: END IF;
1593: IF (p_invoice_num <> FND_API.G_MISS_CHAR) THEN
1594: DBMS_SQL.BIND_VARIABLE(l_handle,'p_invoice_num',p_invoice_num);
1595: END IF;

Line 1594: DBMS_SQL.BIND_VARIABLE(l_handle,'p_invoice_num',p_invoice_num);

1590: IF (p_pr_date_to <> FND_API.G_MISS_DATE) THEN
1591: DBMS_SQL.BIND_VARIABLE(l_handle,'p_pr_date_to',p_pr_date_to);
1592: END IF;
1593: IF (p_invoice_num <> FND_API.G_MISS_CHAR) THEN
1594: DBMS_SQL.BIND_VARIABLE(l_handle,'p_invoice_num',p_invoice_num);
1595: END IF;
1596: IF (p_order_num <> FND_API.G_MISS_NUM AND p_order_num <> 0) THEN
1597: DBMS_SQL.BIND_VARIABLE(l_handle,'p_order_num',p_order_num);
1598: END IF;

Line 1597: DBMS_SQL.BIND_VARIABLE(l_handle,'p_order_num',p_order_num);

1593: IF (p_invoice_num <> FND_API.G_MISS_CHAR) THEN
1594: DBMS_SQL.BIND_VARIABLE(l_handle,'p_invoice_num',p_invoice_num);
1595: END IF;
1596: IF (p_order_num <> FND_API.G_MISS_NUM AND p_order_num <> 0) THEN
1597: DBMS_SQL.BIND_VARIABLE(l_handle,'p_order_num',p_order_num);
1598: END IF;
1599: IF (p_calc_status <> 'ALL') THEN
1600: DBMS_SQL.BIND_VARIABLE(l_handle,'p_calc_status',p_calc_status);
1601: END IF;

Line 1600: DBMS_SQL.BIND_VARIABLE(l_handle,'p_calc_status',p_calc_status);

1596: IF (p_order_num <> FND_API.G_MISS_NUM AND p_order_num <> 0) THEN
1597: DBMS_SQL.BIND_VARIABLE(l_handle,'p_order_num',p_order_num);
1598: END IF;
1599: IF (p_calc_status <> 'ALL') THEN
1600: DBMS_SQL.BIND_VARIABLE(l_handle,'p_calc_status',p_calc_status);
1601: END IF;
1602:
1603: -- Added for Crediting
1604: IF (l_keep_flag <> FND_API.G_MISS_CHAR AND l_keep_flag <> NULL) THEN

Line 1605: DBMS_SQL.BIND_VARIABLE(l_handle,'l_keep_flag',l_keep_flag);

1601: END IF;
1602:
1603: -- Added for Crediting
1604: IF (l_keep_flag <> FND_API.G_MISS_CHAR AND l_keep_flag <> NULL) THEN
1605: DBMS_SQL.BIND_VARIABLE(l_handle,'l_keep_flag',l_keep_flag);
1606: END IF;
1607:
1608:
1609: DBMS_SQL.DEFINE_COLUMN (l_handle,1,l_direct_salesrep_id);

Line 1609: DBMS_SQL.DEFINE_COLUMN (l_handle,1,l_direct_salesrep_id);

1605: DBMS_SQL.BIND_VARIABLE(l_handle,'l_keep_flag',l_keep_flag);
1606: END IF;
1607:
1608:
1609: DBMS_SQL.DEFINE_COLUMN (l_handle,1,l_direct_salesrep_id);
1610: DBMS_SQL.DEFINE_COLUMN (l_handle,2,l_invoice_number,20);
1611: DBMS_SQL.DEFINE_COLUMN (l_handle,3,l_line_number);
1612: DBMS_SQL.DEFINE_COLUMN (l_handle,4,l_revenue_type,15);
1613: DBMS_SQL.DEFINE_COLUMN (l_handle,5,l_split_pct);

Line 1610: DBMS_SQL.DEFINE_COLUMN (l_handle,2,l_invoice_number,20);

1606: END IF;
1607:
1608:
1609: DBMS_SQL.DEFINE_COLUMN (l_handle,1,l_direct_salesrep_id);
1610: DBMS_SQL.DEFINE_COLUMN (l_handle,2,l_invoice_number,20);
1611: DBMS_SQL.DEFINE_COLUMN (l_handle,3,l_line_number);
1612: DBMS_SQL.DEFINE_COLUMN (l_handle,4,l_revenue_type,15);
1613: DBMS_SQL.DEFINE_COLUMN (l_handle,5,l_split_pct);
1614: DBMS_SQL.DEFINE_COLUMN (l_handle,6,l_salesrep_number,30);

Line 1611: DBMS_SQL.DEFINE_COLUMN (l_handle,3,l_line_number);

1607:
1608:
1609: DBMS_SQL.DEFINE_COLUMN (l_handle,1,l_direct_salesrep_id);
1610: DBMS_SQL.DEFINE_COLUMN (l_handle,2,l_invoice_number,20);
1611: DBMS_SQL.DEFINE_COLUMN (l_handle,3,l_line_number);
1612: DBMS_SQL.DEFINE_COLUMN (l_handle,4,l_revenue_type,15);
1613: DBMS_SQL.DEFINE_COLUMN (l_handle,5,l_split_pct);
1614: DBMS_SQL.DEFINE_COLUMN (l_handle,6,l_salesrep_number,30);
1615: DBMS_SQL.DEFINE_COLUMN (l_handle,7,l_comm_lines_api_id);

Line 1612: DBMS_SQL.DEFINE_COLUMN (l_handle,4,l_revenue_type,15);

1608:
1609: DBMS_SQL.DEFINE_COLUMN (l_handle,1,l_direct_salesrep_id);
1610: DBMS_SQL.DEFINE_COLUMN (l_handle,2,l_invoice_number,20);
1611: DBMS_SQL.DEFINE_COLUMN (l_handle,3,l_line_number);
1612: DBMS_SQL.DEFINE_COLUMN (l_handle,4,l_revenue_type,15);
1613: DBMS_SQL.DEFINE_COLUMN (l_handle,5,l_split_pct);
1614: DBMS_SQL.DEFINE_COLUMN (l_handle,6,l_salesrep_number,30);
1615: DBMS_SQL.DEFINE_COLUMN (l_handle,7,l_comm_lines_api_id);
1616: l_return := DBMS_SQL.execute (l_handle);

Line 1613: DBMS_SQL.DEFINE_COLUMN (l_handle,5,l_split_pct);

1609: DBMS_SQL.DEFINE_COLUMN (l_handle,1,l_direct_salesrep_id);
1610: DBMS_SQL.DEFINE_COLUMN (l_handle,2,l_invoice_number,20);
1611: DBMS_SQL.DEFINE_COLUMN (l_handle,3,l_line_number);
1612: DBMS_SQL.DEFINE_COLUMN (l_handle,4,l_revenue_type,15);
1613: DBMS_SQL.DEFINE_COLUMN (l_handle,5,l_split_pct);
1614: DBMS_SQL.DEFINE_COLUMN (l_handle,6,l_salesrep_number,30);
1615: DBMS_SQL.DEFINE_COLUMN (l_handle,7,l_comm_lines_api_id);
1616: l_return := DBMS_SQL.execute (l_handle);
1617: LOOP

Line 1614: DBMS_SQL.DEFINE_COLUMN (l_handle,6,l_salesrep_number,30);

1610: DBMS_SQL.DEFINE_COLUMN (l_handle,2,l_invoice_number,20);
1611: DBMS_SQL.DEFINE_COLUMN (l_handle,3,l_line_number);
1612: DBMS_SQL.DEFINE_COLUMN (l_handle,4,l_revenue_type,15);
1613: DBMS_SQL.DEFINE_COLUMN (l_handle,5,l_split_pct);
1614: DBMS_SQL.DEFINE_COLUMN (l_handle,6,l_salesrep_number,30);
1615: DBMS_SQL.DEFINE_COLUMN (l_handle,7,l_comm_lines_api_id);
1616: l_return := DBMS_SQL.execute (l_handle);
1617: LOOP
1618: IF (dbms_sql.fetch_rows(l_handle) > 0) THEN

Line 1615: DBMS_SQL.DEFINE_COLUMN (l_handle,7,l_comm_lines_api_id);

1611: DBMS_SQL.DEFINE_COLUMN (l_handle,3,l_line_number);
1612: DBMS_SQL.DEFINE_COLUMN (l_handle,4,l_revenue_type,15);
1613: DBMS_SQL.DEFINE_COLUMN (l_handle,5,l_split_pct);
1614: DBMS_SQL.DEFINE_COLUMN (l_handle,6,l_salesrep_number,30);
1615: DBMS_SQL.DEFINE_COLUMN (l_handle,7,l_comm_lines_api_id);
1616: l_return := DBMS_SQL.execute (l_handle);
1617: LOOP
1618: IF (dbms_sql.fetch_rows(l_handle) > 0) THEN
1619: l_counter := l_counter + 1;

Line 1616: l_return := DBMS_SQL.execute (l_handle);

1612: DBMS_SQL.DEFINE_COLUMN (l_handle,4,l_revenue_type,15);
1613: DBMS_SQL.DEFINE_COLUMN (l_handle,5,l_split_pct);
1614: DBMS_SQL.DEFINE_COLUMN (l_handle,6,l_salesrep_number,30);
1615: DBMS_SQL.DEFINE_COLUMN (l_handle,7,l_comm_lines_api_id);
1616: l_return := DBMS_SQL.execute (l_handle);
1617: LOOP
1618: IF (dbms_sql.fetch_rows(l_handle) > 0) THEN
1619: l_counter := l_counter + 1;
1620: DBMS_SQL.COLUMN_VALUE (l_handle,1,l_direct_salesrep_id);

Line 1618: IF (dbms_sql.fetch_rows(l_handle) > 0) THEN

1614: DBMS_SQL.DEFINE_COLUMN (l_handle,6,l_salesrep_number,30);
1615: DBMS_SQL.DEFINE_COLUMN (l_handle,7,l_comm_lines_api_id);
1616: l_return := DBMS_SQL.execute (l_handle);
1617: LOOP
1618: IF (dbms_sql.fetch_rows(l_handle) > 0) THEN
1619: l_counter := l_counter + 1;
1620: DBMS_SQL.COLUMN_VALUE (l_handle,1,l_direct_salesrep_id);
1621: DBMS_SQL.COLUMN_VALUE (l_handle,2,l_invoice_number);
1622: DBMS_SQL.COLUMN_VALUE (l_handle,3,l_line_number);

Line 1620: DBMS_SQL.COLUMN_VALUE (l_handle,1,l_direct_salesrep_id);

1616: l_return := DBMS_SQL.execute (l_handle);
1617: LOOP
1618: IF (dbms_sql.fetch_rows(l_handle) > 0) THEN
1619: l_counter := l_counter + 1;
1620: DBMS_SQL.COLUMN_VALUE (l_handle,1,l_direct_salesrep_id);
1621: DBMS_SQL.COLUMN_VALUE (l_handle,2,l_invoice_number);
1622: DBMS_SQL.COLUMN_VALUE (l_handle,3,l_line_number);
1623: DBMS_SQL.COLUMN_VALUE (l_handle,4,l_revenue_type);
1624: DBMS_SQL.COLUMN_VALUE (l_handle,5,l_split_pct);

Line 1621: DBMS_SQL.COLUMN_VALUE (l_handle,2,l_invoice_number);

1617: LOOP
1618: IF (dbms_sql.fetch_rows(l_handle) > 0) THEN
1619: l_counter := l_counter + 1;
1620: DBMS_SQL.COLUMN_VALUE (l_handle,1,l_direct_salesrep_id);
1621: DBMS_SQL.COLUMN_VALUE (l_handle,2,l_invoice_number);
1622: DBMS_SQL.COLUMN_VALUE (l_handle,3,l_line_number);
1623: DBMS_SQL.COLUMN_VALUE (l_handle,4,l_revenue_type);
1624: DBMS_SQL.COLUMN_VALUE (l_handle,5,l_split_pct);
1625: DBMS_SQL.COLUMN_VALUE (l_handle,6,l_salesrep_number);

Line 1622: DBMS_SQL.COLUMN_VALUE (l_handle,3,l_line_number);

1618: IF (dbms_sql.fetch_rows(l_handle) > 0) THEN
1619: l_counter := l_counter + 1;
1620: DBMS_SQL.COLUMN_VALUE (l_handle,1,l_direct_salesrep_id);
1621: DBMS_SQL.COLUMN_VALUE (l_handle,2,l_invoice_number);
1622: DBMS_SQL.COLUMN_VALUE (l_handle,3,l_line_number);
1623: DBMS_SQL.COLUMN_VALUE (l_handle,4,l_revenue_type);
1624: DBMS_SQL.COLUMN_VALUE (l_handle,5,l_split_pct);
1625: DBMS_SQL.COLUMN_VALUE (l_handle,6,l_salesrep_number);
1626: DBMS_SQL.COLUMN_VALUE (l_handle,7,l_comm_lines_api_id);

Line 1623: DBMS_SQL.COLUMN_VALUE (l_handle,4,l_revenue_type);

1619: l_counter := l_counter + 1;
1620: DBMS_SQL.COLUMN_VALUE (l_handle,1,l_direct_salesrep_id);
1621: DBMS_SQL.COLUMN_VALUE (l_handle,2,l_invoice_number);
1622: DBMS_SQL.COLUMN_VALUE (l_handle,3,l_line_number);
1623: DBMS_SQL.COLUMN_VALUE (l_handle,4,l_revenue_type);
1624: DBMS_SQL.COLUMN_VALUE (l_handle,5,l_split_pct);
1625: DBMS_SQL.COLUMN_VALUE (l_handle,6,l_salesrep_number);
1626: DBMS_SQL.COLUMN_VALUE (l_handle,7,l_comm_lines_api_id);
1627: -- Creating a table of to-be-deleted records.

Line 1624: DBMS_SQL.COLUMN_VALUE (l_handle,5,l_split_pct);

1620: DBMS_SQL.COLUMN_VALUE (l_handle,1,l_direct_salesrep_id);
1621: DBMS_SQL.COLUMN_VALUE (l_handle,2,l_invoice_number);
1622: DBMS_SQL.COLUMN_VALUE (l_handle,3,l_line_number);
1623: DBMS_SQL.COLUMN_VALUE (l_handle,4,l_revenue_type);
1624: DBMS_SQL.COLUMN_VALUE (l_handle,5,l_split_pct);
1625: DBMS_SQL.COLUMN_VALUE (l_handle,6,l_salesrep_number);
1626: DBMS_SQL.COLUMN_VALUE (l_handle,7,l_comm_lines_api_id);
1627: -- Creating a table of to-be-deleted records.
1628: l_existing_data(l_counter).salesrep_id := l_direct_salesrep_id;

Line 1625: DBMS_SQL.COLUMN_VALUE (l_handle,6,l_salesrep_number);

1621: DBMS_SQL.COLUMN_VALUE (l_handle,2,l_invoice_number);
1622: DBMS_SQL.COLUMN_VALUE (l_handle,3,l_line_number);
1623: DBMS_SQL.COLUMN_VALUE (l_handle,4,l_revenue_type);
1624: DBMS_SQL.COLUMN_VALUE (l_handle,5,l_split_pct);
1625: DBMS_SQL.COLUMN_VALUE (l_handle,6,l_salesrep_number);
1626: DBMS_SQL.COLUMN_VALUE (l_handle,7,l_comm_lines_api_id);
1627: -- Creating a table of to-be-deleted records.
1628: l_existing_data(l_counter).salesrep_id := l_direct_salesrep_id;
1629: l_existing_data(l_counter).invoice_number := l_invoice_number;

Line 1626: DBMS_SQL.COLUMN_VALUE (l_handle,7,l_comm_lines_api_id);

1622: DBMS_SQL.COLUMN_VALUE (l_handle,3,l_line_number);
1623: DBMS_SQL.COLUMN_VALUE (l_handle,4,l_revenue_type);
1624: DBMS_SQL.COLUMN_VALUE (l_handle,5,l_split_pct);
1625: DBMS_SQL.COLUMN_VALUE (l_handle,6,l_salesrep_number);
1626: DBMS_SQL.COLUMN_VALUE (l_handle,7,l_comm_lines_api_id);
1627: -- Creating a table of to-be-deleted records.
1628: l_existing_data(l_counter).salesrep_id := l_direct_salesrep_id;
1629: l_existing_data(l_counter).invoice_number := l_invoice_number;
1630: l_existing_data(l_counter).line_number := l_line_number;

Line 1640: DBMS_SQL.close_cursor(l_handle);

1636: ELSE
1637: EXIT;
1638: END IF;
1639: END LOOP;
1640: DBMS_SQL.close_cursor(l_handle);
1641: -- A dummy PL/SQL table need to be created with NULL values to make a
1642: -- call to update_invoice_changes procedure.
1643: l_new_data(1).salesrep_id := NULL;
1644: l_new_data(1).invoice_number := NULL;