DBA Data[Home] [Help]

APPS.QP_JAVA_ENGINE_CACHE_PVT dependencies on FND_GLOBAL

Line 835: l_created_by_final_tbl(i) := FND_GLOBAL.USER_ID;

831:
832: -- populate WHO columns
833: FOR i IN 1..l_cache_type_tbl.last loop
834: l_creation_date_final_tbl(i) := sysdate;
835: l_created_by_final_tbl(i) := FND_GLOBAL.USER_ID;
836: l_last_update_date_final_tbl(i) := sysdate;
837: l_last_updated_by_final_tbl(i) := FND_GLOBAL.USER_ID;
838: l_last_update_login_final_tbl(i) := FND_GLOBAL.LOGIN_ID;
839: l_program_appl_id_final_tbl(i) := FND_GLOBAL.PROG_APPL_ID;

Line 837: l_last_updated_by_final_tbl(i) := FND_GLOBAL.USER_ID;

833: FOR i IN 1..l_cache_type_tbl.last loop
834: l_creation_date_final_tbl(i) := sysdate;
835: l_created_by_final_tbl(i) := FND_GLOBAL.USER_ID;
836: l_last_update_date_final_tbl(i) := sysdate;
837: l_last_updated_by_final_tbl(i) := FND_GLOBAL.USER_ID;
838: l_last_update_login_final_tbl(i) := FND_GLOBAL.LOGIN_ID;
839: l_program_appl_id_final_tbl(i) := FND_GLOBAL.PROG_APPL_ID;
840: l_program_id_final_tbl(i) := FND_GLOBAL.CONC_PROGRAM_ID;
841: l_program_upd_date_final_tbl(i) := sysdate;

Line 838: l_last_update_login_final_tbl(i) := FND_GLOBAL.LOGIN_ID;

834: l_creation_date_final_tbl(i) := sysdate;
835: l_created_by_final_tbl(i) := FND_GLOBAL.USER_ID;
836: l_last_update_date_final_tbl(i) := sysdate;
837: l_last_updated_by_final_tbl(i) := FND_GLOBAL.USER_ID;
838: l_last_update_login_final_tbl(i) := FND_GLOBAL.LOGIN_ID;
839: l_program_appl_id_final_tbl(i) := FND_GLOBAL.PROG_APPL_ID;
840: l_program_id_final_tbl(i) := FND_GLOBAL.CONC_PROGRAM_ID;
841: l_program_upd_date_final_tbl(i) := sysdate;
842: l_request_id_final_tbl(i) := FND_GLOBAL.CONC_REQUEST_ID;

Line 839: l_program_appl_id_final_tbl(i) := FND_GLOBAL.PROG_APPL_ID;

835: l_created_by_final_tbl(i) := FND_GLOBAL.USER_ID;
836: l_last_update_date_final_tbl(i) := sysdate;
837: l_last_updated_by_final_tbl(i) := FND_GLOBAL.USER_ID;
838: l_last_update_login_final_tbl(i) := FND_GLOBAL.LOGIN_ID;
839: l_program_appl_id_final_tbl(i) := FND_GLOBAL.PROG_APPL_ID;
840: l_program_id_final_tbl(i) := FND_GLOBAL.CONC_PROGRAM_ID;
841: l_program_upd_date_final_tbl(i) := sysdate;
842: l_request_id_final_tbl(i) := FND_GLOBAL.CONC_REQUEST_ID;
843: END LOOP;

Line 840: l_program_id_final_tbl(i) := FND_GLOBAL.CONC_PROGRAM_ID;

836: l_last_update_date_final_tbl(i) := sysdate;
837: l_last_updated_by_final_tbl(i) := FND_GLOBAL.USER_ID;
838: l_last_update_login_final_tbl(i) := FND_GLOBAL.LOGIN_ID;
839: l_program_appl_id_final_tbl(i) := FND_GLOBAL.PROG_APPL_ID;
840: l_program_id_final_tbl(i) := FND_GLOBAL.CONC_PROGRAM_ID;
841: l_program_upd_date_final_tbl(i) := sysdate;
842: l_request_id_final_tbl(i) := FND_GLOBAL.CONC_REQUEST_ID;
843: END LOOP;
844:

Line 842: l_request_id_final_tbl(i) := FND_GLOBAL.CONC_REQUEST_ID;

838: l_last_update_login_final_tbl(i) := FND_GLOBAL.LOGIN_ID;
839: l_program_appl_id_final_tbl(i) := FND_GLOBAL.PROG_APPL_ID;
840: l_program_id_final_tbl(i) := FND_GLOBAL.CONC_PROGRAM_ID;
841: l_program_upd_date_final_tbl(i) := sysdate;
842: l_request_id_final_tbl(i) := FND_GLOBAL.CONC_REQUEST_ID;
843: END LOOP;
844:
845: DELETE FROM qp_cache_stats;
846:

Line 1058: qp_java_engine_util_pub.G_HARD_CHAR||'concRequestId='||nvl(FND_GLOBAL.CONC_REQUEST_ID, -1)||

1054: end if;
1055: --update_cat_no_prod_pricing;
1056:
1057: l_url_param_string := 'Action=synchronize'||
1058: qp_java_engine_util_pub.G_HARD_CHAR||'concRequestId='||nvl(FND_GLOBAL.CONC_REQUEST_ID, -1)||
1059: qp_java_engine_util_pub.G_HARD_CHAR||'listHeaderId='||nvl(p_list_header_id, -1)||
1060: qp_java_engine_util_pub.G_HARD_CHAR||'priceFormulaId='||nvl(p_price_formula_id, -1)||
1061: qp_java_engine_util_pub.G_HARD_CHAR||'currencyHeaderId='||nvl(p_currency_header_id, -1)||
1062: qp_java_engine_util_pub.G_HARD_CHAR||'allOthers='||nvl(p_all_others, 'N')||

Line 1076: qp_java_engine_util_pub.G_HARD_CHAR||'concRequestId='||nvl(FND_GLOBAL.CONC_REQUEST_ID, -1)||

1072: IF (l_return_status_text = 'UTL_TCP.END_OF_INPUT') THEN
1073: LOOP
1074: DBMS_LOCK.SLEEP(L_STATUS_REQUEST_INTERVAL);
1075: l_url_param_string := 'Action=synchronize'||
1076: qp_java_engine_util_pub.G_HARD_CHAR||'concRequestId='||nvl(FND_GLOBAL.CONC_REQUEST_ID, -1)||
1077: qp_java_engine_util_pub.G_HARD_CHAR||'statusRequest=Y';
1078: qp_java_engine_util_pub.send_java_engine_request(l_url_param_string,
1079: l_return_status,
1080: l_return_status_text);