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_RESOURCE_EXTNS_INT

Line 138: jtf_rs_resource_extns_int

134: attribute5, attribute6, attribute7, attribute8,
135: attribute9, attribute10, attribute11, attribute12,
136: attribute13, attribute14, attribute15, category
137: FROM
138: jtf_rs_resource_extns_int
139: WHERE
140: batch_id = p_batch_id AND
141: category = 'OTHER' AND
142: operation = 'CREATE' AND

Line 152: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;

148: /*=================Variables for Resource Import========================*/
149: l_api_name VARCHAR2(30);
150: l_init_msg_list VARCHAR2(1);
151: l_commit VARCHAR2(1);
152: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
153: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
154: l_address_id JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE;
155: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;
156: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;

Line 249: UPDATE jtf_rs_resource_extns_int

245: --validate Start Date Active value.
246: -- Get translated value for 'Start Date Active cannot be null'
247: l_trans_message := fnd_message.get_string('JTF','JTF_RS_START_DATE_NULL');
248:
249: UPDATE jtf_rs_resource_extns_int
250: SET OPERATION_STATUS = l_status_error,
251: OPERATION_MESSAGE = l_trans_message,
252: OPERATION_PROCESS_DATE = SYSDATE
253: WHERE batch_id = p_batch_id AND

Line 293: UPDATE jtf_rs_resource_extns_int

289: fnd_msg_pub.add;
290:
291: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
292:
293: UPDATE jtf_rs_resource_extns_int
294: SET OPERATION_STATUS = l_status_error,
295: OPERATION_MESSAGE = l_trans_message,
296: OPERATION_PROCESS_DATE = SYSDATE
297: WHERE batch_id = p_batch_id AND

Line 437: UPDATE jtf_rs_resource_extns_int

433: ---- End of Message data reading logic
434:
435: --When return status is success then update Resource Id to Intf Table.
436: IF l_return_status = l_status_success THEN
437: UPDATE jtf_rs_resource_extns_int
438: SET operation_status = l_status_success,
439: operation_process_date = SYSDATE,
440: resource_id = x_resource_id
441: WHERE interface_id = l_interface_id;

Line 444: UPDATE jtf_rs_resource_extns_int

440: resource_id = x_resource_id
441: WHERE interface_id = l_interface_id;
442: ELSE
443: -- When return status is NOT success,update Error details to Intf Table.
444: UPDATE jtf_rs_resource_extns_int
445: SET operation_status = l_return_status,
446: operation_message = l_msg_data1,
447: operation_process_date = SYSDATE
448: WHERE interface_id = l_interface_id;

Line 477: UPDATE jtf_rs_resource_extns_int

473: END IF;
474:
475: ROLLBACK TO do_create_resource_loop;
476:
477: UPDATE jtf_rs_resource_extns_int
478: SET operation_status = l_return_status,
479: operation_message = l_msg_data1,
480: operation_process_date = SYSDATE
481: WHERE interface_id = l_interface_id;

Line 618: jtf_rs_resource_extns_int

614: resource_id,
615: DECODE(start_date_active,to_char(l_null_date,'dd/mm/yyyy hh24:mi:ss'),NULL,NULL,to_char(l_miss_date,'dd/mm/yyyy hh24:mi:ss'),to_char(start_date_active,'dd/mm/yyyy hh24:mi:ss')) start_date_active_char
616: --Character converted date To compare with l_miss_date.
617: FROM
618: jtf_rs_resource_extns_int
619: WHERE
620: batch_id = p_batch_id AND
621: category = 'OTHER' AND
622: operation = 'UPDATE' AND

Line 639: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;

635: /*=================Variables for Resource Import========================*/
636: l_api_name VARCHAR2(30);
637: l_init_msg_list VARCHAR2(1);
638: l_commit VARCHAR2(1);
639: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
640: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
641: l_address_id JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE;
642: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;
643: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;

Line 735: UPDATE jtf_rs_resource_extns_int

731: -- Get translated value for 'Resource Id cannot be null in Update mode.'
732:
733: l_trans_message := fnd_message.get_string('JTF','JTF_RS_RESOURCE_ID_NULL');
734:
735: UPDATE jtf_rs_resource_extns_int
736: SET operation_status = l_status_error,
737: operation_message = l_trans_message,
738: operation_process_date = SYSDATE
739: WHERE batch_id = p_batch_id AND

Line 765: UPDATE jtf_rs_resource_extns_int rs_int

761: -- Get translated value for 'Resource Id is not valid'
762:
763: l_trans_message := fnd_message.get_string('JTF','JTF_RS_RES_ID_INVALID');
764:
765: UPDATE jtf_rs_resource_extns_int rs_int
766: SET operation_status = l_status_error,
767: operation_message = l_trans_message,
768: operation_process_date = SYSDATE
769: WHERE batch_id = p_batch_id AND

Line 804: UPDATE jtf_rs_resource_extns_int rs_int

800: fnd_msg_pub.add;
801:
802: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
803:
804: UPDATE jtf_rs_resource_extns_int rs_int
805: SET operation_status = l_status_error,
806: operation_message = l_trans_message,
807: operation_process_date = SYSDATE
808: WHERE batch_id = p_batch_id AND

Line 854: UPDATE jtf_rs_resource_extns_int

850: fnd_msg_pub.add;
851:
852: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
853:
854: UPDATE jtf_rs_resource_extns_int
855: SET operation_status = l_status_error,
856: operation_message = l_trans_message,
857: operation_process_date = SYSDATE
858: WHERE batch_id = p_batch_id AND

Line 891: UPDATE jtf_rs_resource_extns_int

887: -- Get translated value for 'Start Date Active cannot be null'
888: l_trans_message := fnd_message.get_string('JTF','JTF_RS_START_DATE_NULL');
889:
890: --'Active Start Date should not be updated to NULL.'
891: UPDATE jtf_rs_resource_extns_int
892: SET operation_status = l_status_error,
893: operation_message = l_trans_message,
894: operation_process_date = SYSDATE
895: WHERE batch_id = p_batch_id AND

Line 1005: UPDATE jtf_rs_resource_extns_int

1001:
1002: l_trans_message := fnd_message.get_string('JTF','JTF_RS_ERR_STDT_GREATER_EDDT');
1003:
1004: --'Date values should be valid'
1005: UPDATE jtf_rs_resource_extns_int
1006: SET operation_status = l_return_status,
1007: operation_message = l_trans_message,
1008: operation_process_date = SYSDATE
1009: WHERE interface_id = l_interface_id;

Line 1129: UPDATE jtf_rs_resource_extns_int

1125: ---- End of Message data reading logic
1126:
1127: --When return status is success then update Status to Interface Table.
1128: IF l_return_status = l_status_success THEN
1129: UPDATE jtf_rs_resource_extns_int
1130: SET operation_status = l_status_success,
1131: operation_process_date = SYSDATE
1132: WHERE interface_id = l_interface_id;
1133: ELSE-- When return status is NOT success then update Error details to Interface Table.

Line 1134: UPDATE jtf_rs_resource_extns_int

1130: SET operation_status = l_status_success,
1131: operation_process_date = SYSDATE
1132: WHERE interface_id = l_interface_id;
1133: ELSE-- When return status is NOT success then update Error details to Interface Table.
1134: UPDATE jtf_rs_resource_extns_int
1135: SET operation_status = l_return_status,
1136: operation_message = l_msg_data1,
1137: operation_process_date = SYSDATE
1138: WHERE interface_id = l_interface_id;

Line 1229: UPDATE jtf_rs_resource_extns_int

1225:
1226:
1227: --When return status is success then update Status to Interface Table.
1228: IF l_return_status = l_status_success THEN
1229: UPDATE jtf_rs_resource_extns_int
1230: SET operation_status = l_status_success,
1231: operation_process_date = SYSDATE
1232: WHERE interface_id = l_interface_id;
1233: ELSE-- When return status is NOT success then update Error details to Interface Table.

Line 1240: UPDATE jtf_rs_resource_extns_int

1236: debug(p_message=>'Error in Update Resource loop at Resource Id,Batch Id, Interface Id : '||l_resource_id||' '||l_batch_id||' '||l_interface_id,
1237: p_prefix =>l_debug_prefix,
1238: p_msg_level=>fnd_log.level_statement);
1239: END IF;
1240: UPDATE jtf_rs_resource_extns_int
1241: SET operation_status = l_return_status,
1242: operation_message = l_msg_data1,
1243: operation_process_date = SYSDATE
1244: WHERE interface_id = l_interface_id;

Line 1303: UPDATE jtf_rs_resource_extns_int

1299:
1300:
1301: --When return status is success then update Status to Interface Table.
1302: IF l_return_status = l_status_success THEN
1303: UPDATE jtf_rs_resource_extns_int
1304: SET operation_status = l_status_success,
1305: operation_process_date = SYSDATE
1306: WHERE interface_id = l_interface_id;
1307: ELSE-- When return status is NOT success then update Error details to Interface Table.

Line 1308: UPDATE jtf_rs_resource_extns_int

1304: SET operation_status = l_status_success,
1305: operation_process_date = SYSDATE
1306: WHERE interface_id = l_interface_id;
1307: ELSE-- When return status is NOT success then update Error details to Interface Table.
1308: UPDATE jtf_rs_resource_extns_int
1309: SET operation_status = l_return_status,
1310: operation_message = l_msg_data1,
1311: operation_process_date = SYSDATE
1312: WHERE interface_id = l_interface_id;

Line 1402: UPDATE jtf_rs_resource_extns_int

1398: ---- End of Message data reading logic
1399:
1400: --When return status is success then update Status to Interface Table.
1401: IF l_return_status = l_status_success THEN
1402: UPDATE jtf_rs_resource_extns_int
1403: SET operation_status = l_status_success,
1404: operation_process_date = SYSDATE
1405: WHERE interface_id = l_interface_id;
1406: ELSE-- When return status is NOT success then update Error details to Interface Table.

Line 1407: UPDATE jtf_rs_resource_extns_int

1403: SET operation_status = l_status_success,
1404: operation_process_date = SYSDATE
1405: WHERE interface_id = l_interface_id;
1406: ELSE-- When return status is NOT success then update Error details to Interface Table.
1407: UPDATE jtf_rs_resource_extns_int
1408: SET operation_status = l_return_status,
1409: operation_message = l_msg_data1,
1410: operation_process_date = SYSDATE
1411: WHERE interface_id = l_interface_id;

Line 1442: UPDATE jtf_rs_resource_extns_int

1438: END IF;
1439:
1440: ROLLBACK TO do_create_resource_loop;
1441:
1442: UPDATE jtf_rs_resource_extns_int
1443: SET operation_status = l_return_status,
1444: operation_message = l_msg_data1,
1445: operation_process_date = SYSDATE
1446: WHERE interface_id = l_interface_id;

Line 1557: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%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;
1559: l_commit_count NUMBER ;
1560: l_api_name VARCHAR2(30);
1561: l_init_msg_list VARCHAR2(1);

Line 1905: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%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;
1906: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
1907: l_commit_count NUMBER ;
1908: l_api_name VARCHAR2(30);
1909: l_init_msg_list VARCHAR2(1);