APPS.WSMPPCPD dependencies on DUAL

Line 1875: ** FROM sys.dual

1871: -- commented out by abedajna on 10/12/00 for perf. tuning
1872: /*
1873: ** SELECT 1
1874: ** INTO x_bom_exists
1875: ** FROM sys.dual
1876: ** WHERE EXISTS (SELECT 1
1877: ** FROM bom_bill_of_materials bbom
1878: ** WHERE bbom.assembly_item_id = x_co_product_id
1879: ** AND bbom.organization_id = x_org_id

Line 1962: x_duality_flag IN VARCHAR2 DEFAULT NULL,

1958: PROCEDURE process_co_product(x_process_code IN NUMBER,
1959: x_rowid IN VARCHAR2 DEFAULT NULL,
1960: x_co_product_group_id IN NUMBER DEFAULT NULL,
1961: x_usage IN NUMBER DEFAULT NULL,
1962: x_duality_flag IN VARCHAR2 DEFAULT NULL,
1963: x_planning_factor IN NUMBER DEFAULT NULL,
1964: x_component_yield_factor IN NUMBER DEFAULT NULL,
1965: x_include_in_cost_rollup IN NUMBER DEFAULT NULL,
1966: x_wip_supply_type IN NUMBER DEFAULT NULL,

Line 2054: FROM sys.dual

2050:
2051: /* Bug# 1418668. Commented the cursor as it is not used any where
2052: CURSOR C (x_bill_seq_id NUMBER)IS
2053: SELECT 1
2054: FROM sys.dual
2055: WHERE EXISTS (SELECT 1
2056: FROM bom_inventory_components bic
2057: WHERE bic.bill_sequence_id = x_bill_seq_id
2058: AND (x_disable_date is NULL

Line 3199: x_duality_flag IN VARCHAR2,

3195: x_effectivity_date IN DATE,
3196: x_disable_date IN DATE,
3197: x_usage_rate IN NUMBER,
3198: x_inv_usage IN NUMBER,
3199: x_duality_flag IN VARCHAR2,
3200: x_basis_type IN NUMBER, --LBM enh
3201: x_comp_attribute_category IN VARCHAR2,
3202: x_comp_attribute1 IN VARCHAR2,
3203: x_comp_attribute2 IN VARCHAR2,

Line 3258: x_duality_flag => x_duality_flag,

3254: x_usage => x_usage_rate,
3255: x_split => S_rec.split,
3256: x_effectivity_date => x_effectivity_date,
3257: x_disable_date => x_disable_date,
3258: x_duality_flag => x_duality_flag,
3259: x_basis_type => x_basis_type, --LBM enh
3260: x_comp_attribute_category => x_comp_attribute_category,
3261: x_comp_attribute1 => x_comp_attribute1,
3262: x_comp_attribute2 => x_comp_attribute2,

Line 3295: duality_flag = x_duality_flag

3291: UPDATE wsm_co_products
3292: SET effectivity_date = x_effectivity_date,
3293: disable_date = x_disable_date,
3294: usage_rate = x_usage_rate,
3295: duality_flag = x_duality_flag
3296: WHERE co_product_group_id = x_co_product_group_id;
3297:
3298: x_error_code := 0;
3299:

Line 3469: FROM dual;

3465: )
3466: )
3467: )
3468: INTO l_file_dir
3469: FROM dual;
3470:
3471: -- check if the dir is valid
3472: BEGIN
3473: fileHandler := UTL_FILE.FOPEN(l_file_dir , 'wsmdbg.log', 'w');