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.JTF_RS_INTERFACE_PVT dependencies on JTF_RS_SALESREPS

Line 1535: jtf_rs_salesreps_int

1531: org_id, email_address, gl_id_rev,
1532: gl_id_freight, gl_id_rec, set_of_books_id,
1533: sales_tax_geocode, sales_tax_inside_city_limits
1534: FROM
1535: jtf_rs_salesreps_int
1536: WHERE
1537: batch_id = p_batch_id AND
1538: operation = 'CREATE' AND
1539: operation_status IS NULL

Line 1542: l_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;

1538: operation = 'CREATE' AND
1539: operation_status IS NULL
1540: ORDER BY interface_id;
1541:
1542: l_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;
1543: l_sales_credit_type_id JTF_RS_SALESREPS.sales_credit_type_id%TYPE;
1544: l_status JTF_RS_SALESREPS.status%TYPE;
1545: l_salesrep_number JTF_RS_SALESREPS.salesrep_number%TYPE;
1546: l_org_id JTF_RS_SALESREPS.org_id%TYPE;

Line 1543: l_sales_credit_type_id JTF_RS_SALESREPS.sales_credit_type_id%TYPE;

1539: operation_status IS NULL
1540: ORDER BY interface_id;
1541:
1542: l_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;
1543: l_sales_credit_type_id JTF_RS_SALESREPS.sales_credit_type_id%TYPE;
1544: l_status JTF_RS_SALESREPS.status%TYPE;
1545: l_salesrep_number JTF_RS_SALESREPS.salesrep_number%TYPE;
1546: l_org_id JTF_RS_SALESREPS.org_id%TYPE;
1547: l_email_address JTF_RS_SALESREPS.email_address%TYPE;

Line 1544: l_status JTF_RS_SALESREPS.status%TYPE;

1540: ORDER BY interface_id;
1541:
1542: l_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;
1543: l_sales_credit_type_id JTF_RS_SALESREPS.sales_credit_type_id%TYPE;
1544: l_status JTF_RS_SALESREPS.status%TYPE;
1545: l_salesrep_number JTF_RS_SALESREPS.salesrep_number%TYPE;
1546: l_org_id JTF_RS_SALESREPS.org_id%TYPE;
1547: l_email_address JTF_RS_SALESREPS.email_address%TYPE;
1548: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;

Line 1545: l_salesrep_number JTF_RS_SALESREPS.salesrep_number%TYPE;

1541:
1542: l_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;
1543: l_sales_credit_type_id JTF_RS_SALESREPS.sales_credit_type_id%TYPE;
1544: l_status JTF_RS_SALESREPS.status%TYPE;
1545: l_salesrep_number JTF_RS_SALESREPS.salesrep_number%TYPE;
1546: l_org_id JTF_RS_SALESREPS.org_id%TYPE;
1547: l_email_address JTF_RS_SALESREPS.email_address%TYPE;
1548: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;
1549: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;

Line 1546: l_org_id JTF_RS_SALESREPS.org_id%TYPE;

1542: l_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;
1543: l_sales_credit_type_id JTF_RS_SALESREPS.sales_credit_type_id%TYPE;
1544: l_status JTF_RS_SALESREPS.status%TYPE;
1545: l_salesrep_number JTF_RS_SALESREPS.salesrep_number%TYPE;
1546: l_org_id JTF_RS_SALESREPS.org_id%TYPE;
1547: l_email_address JTF_RS_SALESREPS.email_address%TYPE;
1548: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;
1549: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;
1550: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;

Line 1547: l_email_address JTF_RS_SALESREPS.email_address%TYPE;

1543: l_sales_credit_type_id JTF_RS_SALESREPS.sales_credit_type_id%TYPE;
1544: l_status JTF_RS_SALESREPS.status%TYPE;
1545: l_salesrep_number JTF_RS_SALESREPS.salesrep_number%TYPE;
1546: l_org_id JTF_RS_SALESREPS.org_id%TYPE;
1547: l_email_address JTF_RS_SALESREPS.email_address%TYPE;
1548: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;
1549: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;
1550: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;
1551: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;

Line 1548: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;

1544: l_status JTF_RS_SALESREPS.status%TYPE;
1545: l_salesrep_number JTF_RS_SALESREPS.salesrep_number%TYPE;
1546: l_org_id JTF_RS_SALESREPS.org_id%TYPE;
1547: l_email_address JTF_RS_SALESREPS.email_address%TYPE;
1548: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;
1549: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;
1550: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;
1551: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;
1552: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;

Line 1549: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;

1545: l_salesrep_number JTF_RS_SALESREPS.salesrep_number%TYPE;
1546: l_org_id JTF_RS_SALESREPS.org_id%TYPE;
1547: l_email_address JTF_RS_SALESREPS.email_address%TYPE;
1548: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;
1549: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;
1550: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;
1551: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;
1552: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;
1553: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;

Line 1550: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;

1546: l_org_id JTF_RS_SALESREPS.org_id%TYPE;
1547: l_email_address JTF_RS_SALESREPS.email_address%TYPE;
1548: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;
1549: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;
1550: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;
1551: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;
1552: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;
1553: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;
1554: x_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;

Line 1551: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;

1547: l_email_address JTF_RS_SALESREPS.email_address%TYPE;
1548: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;
1549: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;
1550: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;
1551: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;
1552: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;
1553: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;
1554: x_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;
1555: l_start_date_active DATE;--JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;

Line 1552: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;

1548: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;
1549: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;
1550: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;
1551: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;
1552: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;
1553: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;
1554: x_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;
1555: l_start_date_active DATE;--JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
1556: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;

Line 1553: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;

1549: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;
1550: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;
1551: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;
1552: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;
1553: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;
1554: x_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;
1555: l_start_date_active DATE;--JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
1556: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
1557: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;

Line 1554: x_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;

1550: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;
1551: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;
1552: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;
1553: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;
1554: x_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;
1555: l_start_date_active DATE;--JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
1556: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
1557: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
1558: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

Line 1611: UPDATE jtf_rs_salesreps_int

1607: --validate Resource Id value.
1608: --Getting Translated 'Resource Id cannot be null'.
1609: l_trans_message := fnd_message.get_string('JTF','JTF_RS_RESOURCE_ID_NULL');
1610:
1611: UPDATE jtf_rs_salesreps_int
1612: SET OPERATION_STATUS = l_status_error,
1613: OPERATION_MESSAGE = l_trans_message,
1614: OPERATION_PROCESS_DATE = SYSDATE
1615: WHERE batch_id = p_batch_id AND

Line 1647: UPDATE jtf_rs_salesreps_int

1643: --validate Sales Number value.
1644: --Getting Translated 'Salesperson number is required to setup a salesperson.'.
1645: l_trans_message := fnd_message.get_string('JTF','JTF_RS_SALESREP_NUMBER_NULL');
1646:
1647: UPDATE jtf_rs_salesreps_int
1648: SET OPERATION_STATUS = l_status_error,
1649: OPERATION_MESSAGE = l_trans_message,
1650: OPERATION_PROCESS_DATE = SYSDATE
1651: WHERE batch_id = p_batch_id AND

Line 1695: JTF_RS_SALESREPS_PUB.create_salesrep

1691: p_msg_level=>fnd_log.level_statement);
1692: END IF;
1693:
1694: --Call the Public procedure to Create Salesrep.
1695: JTF_RS_SALESREPS_PUB.create_salesrep
1696: (p_api_version => 1.0,
1697: p_init_msg_list => l_init_msg_list,
1698: p_commit => l_commit,
1699: p_resource_id => l_resource_id,

Line 1750: UPDATE jtf_rs_salesreps_int

1746: ---- End of Message data reading logic
1747:
1748:
1749: IF l_return_status = l_status_success THEN
1750: UPDATE jtf_rs_salesreps_int
1751: SET operation_status = l_status_success,
1752: operation_process_date = SYSDATE,
1753: salesrep_id = x_salesrep_id
1754: WHERE interface_id = l_interface_id;

Line 1756: UPDATE jtf_rs_salesreps_int

1752: operation_process_date = SYSDATE,
1753: salesrep_id = x_salesrep_id
1754: WHERE interface_id = l_interface_id;
1755: ELSE
1756: UPDATE jtf_rs_salesreps_int
1757: SET operation_status = l_return_status,
1758: operation_message = l_msg_data1,
1759: operation_process_date = SYSDATE
1760: WHERE interface_id = l_interface_id;

Line 1789: UPDATE jtf_rs_salesreps_int

1785: END IF;
1786:
1787: ROLLBACK TO do_create_salesrep_loop;
1788:
1789: UPDATE jtf_rs_salesreps_int
1790: SET operation_status = l_return_status,
1791: operation_message = l_msg_data1,
1792: operation_process_date = SYSDATE
1793: WHERE interface_id = l_interface_id;

Line 1883: jtf_rs_salesreps_int

1879: DECODE(set_of_books_id,l_null_num,NULL,NULL,l_miss_num,set_of_books_id) set_of_books_id,
1880: DECODE( sales_tax_geocode,l_null_char,NULL,NULL,l_miss_char, sales_tax_geocode) sales_tax_geocode,
1881: DECODE(sales_tax_inside_city_limits,l_null_char,NULL,NULL,l_miss_char,sales_tax_inside_city_limits) sales_tax_inside_city_limits
1882: FROM
1883: jtf_rs_salesreps_int
1884: WHERE
1885: batch_id = p_batch_id AND
1886: operation = 'UPDATE' AND
1887: operation_status IS NULL

Line 1890: l_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;

1886: operation = 'UPDATE' AND
1887: operation_status IS NULL
1888: ORDER BY interface_id;
1889:
1890: l_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;
1891: l_sales_credit_type_id JTF_RS_SALESREPS.sales_credit_type_id%TYPE;
1892: l_status JTF_RS_SALESREPS.status%TYPE;
1893: l_salesrep_number JTF_RS_SALESREPS.salesrep_number%TYPE;
1894: l_org_id JTF_RS_SALESREPS.org_id%TYPE;

Line 1891: l_sales_credit_type_id JTF_RS_SALESREPS.sales_credit_type_id%TYPE;

1887: operation_status IS NULL
1888: ORDER BY interface_id;
1889:
1890: l_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;
1891: l_sales_credit_type_id JTF_RS_SALESREPS.sales_credit_type_id%TYPE;
1892: l_status JTF_RS_SALESREPS.status%TYPE;
1893: l_salesrep_number JTF_RS_SALESREPS.salesrep_number%TYPE;
1894: l_org_id JTF_RS_SALESREPS.org_id%TYPE;
1895: l_email_address JTF_RS_SALESREPS.email_address%TYPE;

Line 1892: l_status JTF_RS_SALESREPS.status%TYPE;

1888: ORDER BY interface_id;
1889:
1890: l_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;
1891: l_sales_credit_type_id JTF_RS_SALESREPS.sales_credit_type_id%TYPE;
1892: l_status JTF_RS_SALESREPS.status%TYPE;
1893: l_salesrep_number JTF_RS_SALESREPS.salesrep_number%TYPE;
1894: l_org_id JTF_RS_SALESREPS.org_id%TYPE;
1895: l_email_address JTF_RS_SALESREPS.email_address%TYPE;
1896: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;

Line 1893: l_salesrep_number JTF_RS_SALESREPS.salesrep_number%TYPE;

1889:
1890: l_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;
1891: l_sales_credit_type_id JTF_RS_SALESREPS.sales_credit_type_id%TYPE;
1892: l_status JTF_RS_SALESREPS.status%TYPE;
1893: l_salesrep_number JTF_RS_SALESREPS.salesrep_number%TYPE;
1894: l_org_id JTF_RS_SALESREPS.org_id%TYPE;
1895: l_email_address JTF_RS_SALESREPS.email_address%TYPE;
1896: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;
1897: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;

Line 1894: l_org_id JTF_RS_SALESREPS.org_id%TYPE;

1890: l_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;
1891: l_sales_credit_type_id JTF_RS_SALESREPS.sales_credit_type_id%TYPE;
1892: l_status JTF_RS_SALESREPS.status%TYPE;
1893: l_salesrep_number JTF_RS_SALESREPS.salesrep_number%TYPE;
1894: l_org_id JTF_RS_SALESREPS.org_id%TYPE;
1895: l_email_address JTF_RS_SALESREPS.email_address%TYPE;
1896: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;
1897: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;
1898: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;

Line 1895: l_email_address JTF_RS_SALESREPS.email_address%TYPE;

1891: l_sales_credit_type_id JTF_RS_SALESREPS.sales_credit_type_id%TYPE;
1892: l_status JTF_RS_SALESREPS.status%TYPE;
1893: l_salesrep_number JTF_RS_SALESREPS.salesrep_number%TYPE;
1894: l_org_id JTF_RS_SALESREPS.org_id%TYPE;
1895: l_email_address JTF_RS_SALESREPS.email_address%TYPE;
1896: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;
1897: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;
1898: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;
1899: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;

Line 1896: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;

1892: l_status JTF_RS_SALESREPS.status%TYPE;
1893: l_salesrep_number JTF_RS_SALESREPS.salesrep_number%TYPE;
1894: l_org_id JTF_RS_SALESREPS.org_id%TYPE;
1895: l_email_address JTF_RS_SALESREPS.email_address%TYPE;
1896: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;
1897: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;
1898: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;
1899: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;
1900: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;

Line 1897: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;

1893: l_salesrep_number JTF_RS_SALESREPS.salesrep_number%TYPE;
1894: l_org_id JTF_RS_SALESREPS.org_id%TYPE;
1895: l_email_address JTF_RS_SALESREPS.email_address%TYPE;
1896: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;
1897: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;
1898: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;
1899: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;
1900: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;
1901: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;

Line 1898: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;

1894: l_org_id JTF_RS_SALESREPS.org_id%TYPE;
1895: l_email_address JTF_RS_SALESREPS.email_address%TYPE;
1896: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;
1897: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;
1898: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;
1899: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;
1900: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;
1901: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;
1902: l_object_version_number JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE;

Line 1899: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;

1895: l_email_address JTF_RS_SALESREPS.email_address%TYPE;
1896: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;
1897: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;
1898: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;
1899: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;
1900: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;
1901: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;
1902: l_object_version_number JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE;
1903: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;

Line 1900: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;

1896: l_gl_id_rev JTF_RS_SALESREPS.gl_id_rev%TYPE;
1897: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;
1898: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;
1899: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;
1900: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;
1901: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;
1902: l_object_version_number JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE;
1903: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
1904: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;

Line 1901: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;

1897: l_gl_id_freight JTF_RS_SALESREPS.gl_id_freight%TYPE;
1898: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;
1899: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;
1900: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;
1901: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;
1902: l_object_version_number JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE;
1903: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
1904: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
1905: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;

Line 1959: UPDATE jtf_rs_salesreps_int

1955: --Getting Translated 'Salesrep Id cannot be null.'.
1956:
1957: l_trans_message := fnd_message.get_string('JTF','JTF_RS_SALESREP_ID_NULL');
1958:
1959: UPDATE jtf_rs_salesreps_int
1960: SET OPERATION_STATUS = l_status_error,
1961: OPERATION_MESSAGE = l_trans_message,
1962: OPERATION_PROCESS_DATE = SYSDATE
1963: WHERE batch_id = p_batch_id AND

Line 1992: UPDATE jtf_rs_salesreps_int a

1988: fnd_msg_pub.add;
1989:
1990: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
1991:
1992: UPDATE jtf_rs_salesreps_int a
1993: SET OPERATION_STATUS = l_status_error,
1994: OPERATION_MESSAGE = l_trans_message,
1995: OPERATION_PROCESS_DATE = SYSDATE
1996: WHERE batch_id = p_batch_id AND

Line 1999: NOT EXISTS (SELECT 1 FROM jtf_rs_salesreps B

1995: OPERATION_PROCESS_DATE = SYSDATE
1996: WHERE batch_id = p_batch_id AND
1997: operation = 'UPDATE' AND
1998: operation_status IS NULL AND
1999: NOT EXISTS (SELECT 1 FROM jtf_rs_salesreps B
2000: WHERE A.salesrep_id = B.salesrep_id);
2001:
2002: -- Get the number of rows updated
2003: l_commit_count := SQL%ROWCOUNT ;

Line 2038: FROM JTF_RS_SALESREPS

2034: SAVEPOINT do_update_salesrep_loop;
2035:
2036: SELECT object_version_number,org_id
2037: INTO l_object_version_number,l_org_id
2038: FROM JTF_RS_SALESREPS
2039: WHERE salesrep_id = l_salesrep_id;
2040:
2041: -- Debug info.
2042: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2050: JTF_RS_SALESREPS_PUB.update_salesrep

2046: p_msg_level=>fnd_log.level_statement);
2047: END IF;
2048:
2049: --Call the Public procedure to Update Salesrep.
2050: JTF_RS_SALESREPS_PUB.update_salesrep
2051: (p_api_version => 1.0,
2052: p_init_msg_list => l_init_msg_list,
2053: p_commit => l_commit,
2054: p_sales_credit_type_id => l_sales_credit_type_id,

Line 2105: UPDATE jtf_rs_salesreps_int

2101: END IF;
2102: ---- End of Message data reading logic
2103:
2104: IF l_return_status = l_status_success THEN
2105: UPDATE jtf_rs_salesreps_int
2106: SET operation_status = l_status_success,
2107: operation_process_date = SYSDATE
2108: WHERE interface_id = l_interface_id;
2109: ELSE

Line 2110: UPDATE jtf_rs_salesreps_int

2106: SET operation_status = l_status_success,
2107: operation_process_date = SYSDATE
2108: WHERE interface_id = l_interface_id;
2109: ELSE
2110: UPDATE jtf_rs_salesreps_int
2111: SET operation_status = l_return_status,
2112: operation_message = l_msg_data1,
2113: operation_process_date = SYSDATE
2114: WHERE interface_id = l_interface_id;

Line 2144: UPDATE jtf_rs_salesreps_int

2140: END IF;
2141:
2142: ROLLBACK TO do_update_salesrep_loop;
2143:
2144: UPDATE jtf_rs_salesreps_int
2145: SET operation_status = l_return_status,
2146: operation_message = l_msg_data1,
2147: operation_process_date = SYSDATE
2148: WHERE interface_id = l_interface_id;