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 1212: struct_name IN VARCHAR2 DEFAULT FND_LOAD_UTIL.NULL_VALUE,

1208: organization_option IN NUMBER default 1,
1209: organization_hierarchy IN VARCHAR2 default NULL,
1210: serial_number_from IN VARCHAR2 default NULL,
1211: serial_number_to IN VARCHAR2 default NULL,
1212: struct_name IN VARCHAR2 DEFAULT FND_LOAD_UTIL.NULL_VALUE,
1213: struct_type IN VARCHAR2,
1214: preferred_only IN NUMBER DEFAULT 2,
1215: used_in_structure OUT NOCOPY VARCHAR2
1216: )

Line 1276: struct_name IN VARCHAR2 DEFAULT FND_LOAD_UTIL.NULL_VALUE,

1272: organization_option IN NUMBER default 1,
1273: organization_hierarchy IN VARCHAR2 default NULL,
1274: serial_number_from IN VARCHAR2 default NULL,
1275: serial_number_to IN VARCHAR2 default NULL,
1276: struct_name IN VARCHAR2 DEFAULT FND_LOAD_UTIL.NULL_VALUE,
1277: revision IN VARCHAR2
1278: )
1279: AS
1280: a_err_msg VARCHAR2(2000); --bug:4204847 Increasing the length so that component path can be

Line 1614: struct_name IN VARCHAR2 DEFAULT FND_LOAD_UTIL.NULL_VALUE,

1610: organization_option IN NUMBER default 1,
1611: organization_hierarchy IN VARCHAR2 default NULL,
1612: serial_number_from IN VARCHAR2 default NULL,
1613: serial_number_to IN VARCHAR2 default NULL,
1614: struct_name IN VARCHAR2 DEFAULT FND_LOAD_UTIL.NULL_VALUE,
1615: struct_type IN VARCHAR2,
1616: preferred_only IN NUMBER DEFAULT 2,
1617: used_in_structure OUT NOCOPY VARCHAR2,
1618: revision IN VARCHAR2