DBA Data[Home] [Help]

APPS.BOM_IMPLODER_PUB dependencies on FND_LOAD_UTIL

Line 112: struct_name IN VARCHAR2 DEFAULT FND_LOAD_UTIL.NULL_VALUE

108: organization_option IN NUMBER default 1,
109: organization_hierarchy IN VARCHAR2 default NULL,
110: serial_number_from IN VARCHAR2 default NULL,
111: serial_number_to IN VARCHAR2 default NULL,
112: struct_name IN VARCHAR2 DEFAULT FND_LOAD_UTIL.NULL_VALUE
113: )
114: AS
115: BEGIN
116: imploder_userexit(

Line 157: struct_name IN VARCHAR2 DEFAULT FND_LOAD_UTIL.NULL_VALUE,

153: err_msg OUT NOCOPY VARCHAR2,
154: err_code OUT NOCOPY NUMBER,
155: serial_number_from IN VARCHAR2 default NULL,
156: serial_number_to IN VARCHAR2 default NULL ,
157: struct_name IN VARCHAR2 DEFAULT FND_LOAD_UTIL.NULL_VALUE,
158: revision IN VARCHAR2) AS
159:
160: implosion_date VARCHAR2(25);
161: error_msg VARCHAR(2000);--bug:4204847 Increasing the length so that component path can be

Line 200: struct_name IN VARCHAR2 DEFAULT FND_LOAD_UTIL.NULL_VALUE,

196: err_msg OUT NOCOPY VARCHAR2,
197: error_code OUT NOCOPY NUMBER,
198: serial_number_from IN VARCHAR2,
199: serial_number_to IN VARCHAR2,
200: struct_name IN VARCHAR2 DEFAULT FND_LOAD_UTIL.NULL_VALUE,
201: revision IN VARCHAR2) AS
202:
203: prev_parent_item_id NUMBER;
204: cum_count NUMBER;

Line 296: and ( (struct_name = FND_LOAD_UTIL.NULL_VALUE)

292: and bitt.parent_pk1_value = bic.pk1_value
293: /* Bug#7389906 Ends here*/
294: and bic.bill_sequence_id = bbm.common_bill_sequence_id
295: and bbm.organization_id = c_org_id
296: and ( (struct_name = FND_LOAD_UTIL.NULL_VALUE)
297: or
298: ( struct_name is null AND bbm.alternate_bom_designator is null )
299: or ( bbm.alternate_bom_designator = struct_name ) )
300: and NVL(BIC.ECO_FOR_PRODUCTION,2) = 2

Line 1204: struct_name IN VARCHAR2 DEFAULT FND_LOAD_UTIL.NULL_VALUE,

1200: organization_option IN NUMBER default 1,
1201: organization_hierarchy IN VARCHAR2 default NULL,
1202: serial_number_from IN VARCHAR2 default NULL,
1203: serial_number_to IN VARCHAR2 default NULL,
1204: struct_name IN VARCHAR2 DEFAULT FND_LOAD_UTIL.NULL_VALUE,
1205: struct_type IN VARCHAR2,
1206: preferred_only IN NUMBER DEFAULT 2,
1207: used_in_structure OUT NOCOPY VARCHAR2
1208: )

Line 1268: struct_name IN VARCHAR2 DEFAULT FND_LOAD_UTIL.NULL_VALUE,

1264: organization_option IN NUMBER default 1,
1265: organization_hierarchy IN VARCHAR2 default NULL,
1266: serial_number_from IN VARCHAR2 default NULL,
1267: serial_number_to IN VARCHAR2 default NULL,
1268: struct_name IN VARCHAR2 DEFAULT FND_LOAD_UTIL.NULL_VALUE,
1269: revision IN VARCHAR2
1270: )
1271: AS
1272: a_err_msg VARCHAR2(2000); --bug:4204847 Increasing the length so that component path can be

Line 1606: struct_name IN VARCHAR2 DEFAULT FND_LOAD_UTIL.NULL_VALUE,

1602: organization_option IN NUMBER default 1,
1603: organization_hierarchy IN VARCHAR2 default NULL,
1604: serial_number_from IN VARCHAR2 default NULL,
1605: serial_number_to IN VARCHAR2 default NULL,
1606: struct_name IN VARCHAR2 DEFAULT FND_LOAD_UTIL.NULL_VALUE,
1607: struct_type IN VARCHAR2,
1608: preferred_only IN NUMBER DEFAULT 2,
1609: used_in_structure OUT NOCOPY VARCHAR2,
1610: revision IN VARCHAR2