APPS.JTF_RS_INTERFACE_PVT dependencies on JTF_RS_SALESREPS_INT

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 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 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 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 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;