APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_ITEM_SOURCING_S

Line 27638: lv_default_sourcing_rule msc_st_item_sourcing.sourcing_rule_name%TYPE

27634: lv_where_str VARCHAR2(5000);
27635: lv_sql_stmt VARCHAR2(5000);
27636: lv_cursor_stmt VARCHAR2(5000);
27637:
27638: lv_default_sourcing_rule msc_st_item_sourcing.sourcing_rule_name%TYPE
27639: := v_instance_code||':'||'SRULE' ;
27640: lv_default_assignment_set msc_st_item_sourcing.sourcing_rule_name%TYPE
27641: := 'ASET' ;
27642: lv_default_category_set msc_st_category_sets.category_set_name%TYPE := NULL_CHAR ;

Line 27640: lv_default_assignment_set msc_st_item_sourcing.sourcing_rule_name%TYPE

27636: lv_cursor_stmt VARCHAR2(5000);
27637:
27638: lv_default_sourcing_rule msc_st_item_sourcing.sourcing_rule_name%TYPE
27639: := v_instance_code||':'||'SRULE' ;
27640: lv_default_assignment_set msc_st_item_sourcing.sourcing_rule_name%TYPE
27641: := 'ASET' ;
27642: lv_default_category_set msc_st_category_sets.category_set_name%TYPE := NULL_CHAR ;
27643: lv_batch_id msc_st_item_sourcing.batch_id%TYPE;
27644: lv_message_text msc_errors.error_text%TYPE;

Line 27946: SET st_transaction_id = msc_st_item_sourcing_s.NEXTVAL,

27942:
27943: v_sql_stmt := 05;
27944: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
27945: UPDATE msc_st_item_sourcing
27946: SET st_transaction_id = msc_st_item_sourcing_s.NEXTVAL,
27947: refresh_id = v_refresh_id,
27948: last_update_date = v_current_date,
27949: last_updated_by = v_current_user,
27950: creation_date = v_current_date,