DBA Data[Home] [Help]

APPS.XDP_ENGINE dependencies on FND_GLOBAL

Line 562: set last_updated_by = FND_GLOBAL.USER_ID,

558: FOR v_update_prov_date in c_update_prov_date LOOP
559: if v_update_prov_date.status NOT in ('IN PROGRESS','SUCCESS','SUCCESS_WITH_OVERRIDE','CANCELED') then
560:
561: update XDP_FULFILL_WORKLIST
562: set last_updated_by = FND_GLOBAL.USER_ID,
563: last_update_date = sysdate,
564: last_update_login = FND_GLOBAL.LOGIN_ID,
565: provisioning_date = p_prov_date
566: where current of c_update_prov_date;

Line 564: last_update_login = FND_GLOBAL.LOGIN_ID,

560:
561: update XDP_FULFILL_WORKLIST
562: set last_updated_by = FND_GLOBAL.USER_ID,
563: last_update_date = sysdate,
564: last_update_login = FND_GLOBAL.LOGIN_ID,
565: provisioning_date = p_prov_date
566: where current of c_update_prov_date;
567:
568: else

Line 1033: last_updated_by = FND_GLOBAL.USER_ID,

1029:
1030: IF lv_exists = 'Y' then
1031: update xdp_order_parameters
1032: set
1033: last_updated_by = FND_GLOBAL.USER_ID,
1034: last_update_date = sysdate,
1035: last_update_login = FND_GLOBAL.LOGIN_ID,
1036: order_parameter_value = p_parameter_value
1037: where

Line 1035: last_update_login = FND_GLOBAL.LOGIN_ID,

1031: update xdp_order_parameters
1032: set
1033: last_updated_by = FND_GLOBAL.USER_ID,
1034: last_update_date = sysdate,
1035: last_update_login = FND_GLOBAL.LOGIN_ID,
1036: order_parameter_value = p_parameter_value
1037: where
1038: order_id = p_order_id and
1039: order_parameter_name = p_parameter_name;

Line 1169: last_updated_by = FND_GLOBAL.USER_ID,

1165: end if;
1166:
1167: update XDP_ORDER_LINEITEM_DETS
1168: set
1169: last_updated_by = FND_GLOBAL.USER_ID,
1170: last_update_date = sysdate,
1171: last_update_login = FND_GLOBAL.LOGIN_ID,
1172: parameter_value = p_parameter_value,
1173: parameter_reference_value = p_parameter_reference_value

Line 1171: last_update_login = FND_GLOBAL.LOGIN_ID,

1167: update XDP_ORDER_LINEITEM_DETS
1168: set
1169: last_updated_by = FND_GLOBAL.USER_ID,
1170: last_update_date = sysdate,
1171: last_update_login = FND_GLOBAL.LOGIN_ID,
1172: parameter_value = p_parameter_value,
1173: parameter_reference_value = p_parameter_reference_value
1174: where
1175: line_item_id = p_line_item_id and

Line 2148: last_updated_by = FND_GLOBAL.USER_ID,

2144: order_ref_name = NVL(p_order_ref_name,lv_ref_name),
2145: order_ref_value = NVL(p_order_ref_value,lv_ref_val),
2146: sp_order_number = NVL(p_sp_order_number,lv_sp_order),
2147: --sp_userid = NVL(p_sp_user_id,lv_sp_uid),
2148: last_updated_by = FND_GLOBAL.USER_ID,
2149: last_update_date = sysdate,
2150: last_update_login = FND_GLOBAL.LOGIN_ID
2151: where order_id = p_order_id;
2152:

Line 2150: last_update_login = FND_GLOBAL.LOGIN_ID

2146: sp_order_number = NVL(p_sp_order_number,lv_sp_order),
2147: --sp_userid = NVL(p_sp_user_id,lv_sp_uid),
2148: last_updated_by = FND_GLOBAL.USER_ID,
2149: last_update_date = sysdate,
2150: last_update_login = FND_GLOBAL.LOGIN_ID
2151: where order_id = p_order_id;
2152:
2153:
2154: EXCEPTION

Line 2477: FND_GLOBAL.USER_ID,

2473: values
2474: ( p_order_id,
2475: p_parameter_name,
2476: p_parameter_value,
2477: FND_GLOBAL.USER_ID,
2478: sysdate,
2479: FND_GLOBAL.USER_ID,
2480: sysdate,
2481: FND_GLOBAL.LOGIN_ID

Line 2479: FND_GLOBAL.USER_ID,

2475: p_parameter_name,
2476: p_parameter_value,
2477: FND_GLOBAL.USER_ID,
2478: sysdate,
2479: FND_GLOBAL.USER_ID,
2480: sysdate,
2481: FND_GLOBAL.LOGIN_ID
2482: );
2483:

Line 2481: FND_GLOBAL.LOGIN_ID

2477: FND_GLOBAL.USER_ID,
2478: sysdate,
2479: FND_GLOBAL.USER_ID,
2480: sysdate,
2481: FND_GLOBAL.LOGIN_ID
2482: );
2483:
2484: end LoadOrderParameters;
2485:

Line 2509: FND_GLOBAL.USER_ID,

2505: ( p_line_item_id,
2506: p_parameter_name,
2507: p_parameter_value,
2508: p_parameter_reference_value,
2509: FND_GLOBAL.USER_ID,
2510: sysdate,
2511: FND_GLOBAL.USER_ID,
2512: sysdate,
2513: FND_GLOBAL.LOGIN_ID

Line 2511: FND_GLOBAL.USER_ID,

2507: p_parameter_value,
2508: p_parameter_reference_value,
2509: FND_GLOBAL.USER_ID,
2510: sysdate,
2511: FND_GLOBAL.USER_ID,
2512: sysdate,
2513: FND_GLOBAL.LOGIN_ID
2514: );
2515:

Line 2513: FND_GLOBAL.LOGIN_ID

2509: FND_GLOBAL.USER_ID,
2510: sysdate,
2511: FND_GLOBAL.USER_ID,
2512: sysdate,
2513: FND_GLOBAL.LOGIN_ID
2514: );
2515:
2516: end LoadLineDetails;
2517:

Line 2560: FND_GLOBAL.USER_ID,

2556: p_is_value_evaluated,
2557: p_parameter_value,
2558: p_parameter_ref_value,
2559: 'N',
2560: FND_GLOBAL.USER_ID,
2561: sysdate,
2562: FND_GLOBAL.USER_ID,
2563: sysdate,
2564: FND_GLOBAL.LOGIN_ID

Line 2562: FND_GLOBAL.USER_ID,

2558: p_parameter_ref_value,
2559: 'N',
2560: FND_GLOBAL.USER_ID,
2561: sysdate,
2562: FND_GLOBAL.USER_ID,
2563: sysdate,
2564: FND_GLOBAL.LOGIN_ID
2565: );
2566: END LoadWorklistDetails;

Line 2564: FND_GLOBAL.LOGIN_ID

2560: FND_GLOBAL.USER_ID,
2561: sysdate,
2562: FND_GLOBAL.USER_ID,
2563: sysdate,
2564: FND_GLOBAL.LOGIN_ID
2565: );
2566: END LoadWorklistDetails;
2567:
2568: Procedure UpdateWorklistDetails(

Line 2582: last_updated_by = FND_GLOBAL.USER_ID,

2578: parameter_value = p_parameter_value ,
2579: parameter_ref_value = p_parameter_ref_value,
2580: is_value_evaluated = p_is_value_evaluated,
2581: modified_flag = 'Y',
2582: last_updated_by = FND_GLOBAL.USER_ID,
2583: last_update_date = sysdate,
2584: last_update_login = FND_GLOBAL.LOGIN_ID
2585: WHERE
2586: workitem_instance_id = p_wi_instance_id AND

Line 2584: last_update_login = FND_GLOBAL.LOGIN_ID

2580: is_value_evaluated = p_is_value_evaluated,
2581: modified_flag = 'Y',
2582: last_updated_by = FND_GLOBAL.USER_ID,
2583: last_update_date = sysdate,
2584: last_update_login = FND_GLOBAL.LOGIN_ID
2585: WHERE
2586: workitem_instance_id = p_wi_instance_id AND
2587: parameter_name = p_parameter_name;
2588: END UpdateWorklistDetails;

Line 2619: FND_GLOBAL.USER_ID,

2615: p_fa_id,
2616: p_is_value_evaluated,
2617: p_parameter_value,
2618: p_parameter_ref_value,
2619: FND_GLOBAL.USER_ID,
2620: sysdate,
2621: FND_GLOBAL.USER_ID,
2622: sysdate,
2623: FND_GLOBAL.LOGIN_ID

Line 2621: FND_GLOBAL.USER_ID,

2617: p_parameter_value,
2618: p_parameter_ref_value,
2619: FND_GLOBAL.USER_ID,
2620: sysdate,
2621: FND_GLOBAL.USER_ID,
2622: sysdate,
2623: FND_GLOBAL.LOGIN_ID
2624: );
2625:

Line 2623: FND_GLOBAL.LOGIN_ID

2619: FND_GLOBAL.USER_ID,
2620: sysdate,
2621: FND_GLOBAL.USER_ID,
2622: sysdate,
2623: FND_GLOBAL.LOGIN_ID
2624: );
2625:
2626: end LoadFADetails;
2627:

Line 2642: last_updated_by = FND_GLOBAL.USER_ID,

2638: set
2639: parameter_value = UpdateFaDetails.p_parameter_value,
2640: parameter_ref_value = UpdateFaDetails.p_parameter_ref_value,
2641: is_value_evaluated = UpdateFaDetails.p_evaluated_flag,
2642: last_updated_by = FND_GLOBAL.USER_ID,
2643: last_update_date = sysdate,
2644: last_update_login = FND_GLOBAL.LOGIN_ID
2645: where
2646: fa_instance_id = UpdateFaDetails.p_fa_instance_id and

Line 2644: last_update_login = FND_GLOBAL.LOGIN_ID

2640: parameter_ref_value = UpdateFaDetails.p_parameter_ref_value,
2641: is_value_evaluated = UpdateFaDetails.p_evaluated_flag,
2642: last_updated_by = FND_GLOBAL.USER_ID,
2643: last_update_date = sysdate,
2644: last_update_login = FND_GLOBAL.LOGIN_ID
2645: where
2646: fa_instance_id = UpdateFaDetails.p_fa_instance_id and
2647: parameter_name = UpdateFaDetails.p_parameter_name;
2648: