DBA Data[Home] [Help]

APPS.PO_CORE_S dependencies on FND_PROFILE

Line 80: ALGORITHM : Use fnd_profile.get function to retreive the value

76: OWNER : SUBHAJIT PURKAYASTHA
77:
78: PARAMETERS :
79:
80: ALGORITHM : Use fnd_profile.get function to retreive the value
81:
82: NOTES : Add sqlcode param in the call to po_message_c.sql_error
83: - SI 04/08
84:

Line 93: fnd_profile.get('USSGL_OPTION',x_option_value);

89: x_option_value VARCHAR2(1);
90: begin
91: x_progress := 10;
92:
93: fnd_profile.get('USSGL_OPTION',x_option_value);
94:
95: RETURN(x_option_value);
96:
97: EXCEPTION

Line 118: ALGORITHM : Use fnd_profile.get function to retreive the value

114: OWNER : SUBHAJIT PURKAYASTHA
115:
116: PARAMETERS :
117:
118: ALGORITHM : Use fnd_profile.get function to retreive the value
119:
120: NOTES :
121:
122: =========================================================================== */

Line 132: fnd_profile.get('GL_ACCESS_SET_ID',x_option_value); --

128: x_progress := 10;
129:
130: /* Replaced the profile option name from 'GL_SET_OF_BKS_ID' to GL_ACCESS_SET_ID'*/
131:
132: fnd_profile.get('GL_ACCESS_SET_ID',x_option_value); --
133:
134: RETURN(x_option_value);
135:
136: EXCEPTION

Line 222: ALGORITHM : AOL function fnd_profile.get('MFG_ORGANIZATION_ID') returns

218: PARAMETERS : x_org_id - Return's the Id of the organization
219: x_org_name - Return's the name of the organization
220: x_sob_id - Return's the SOB id
221:
222: ALGORITHM : AOL function fnd_profile.get('MFG_ORGANIZATION_ID') returns
223: the default id of the org.
224: If id <> 0 then
225: retreive organization name and sob id from
226: org_organization_definitions table based on org_id

Line 250: fnd_profile.get('MFG_ORGANIZATION_ID',org_id);

246:
247: sob_id NUMBER;
248: begin
249: x_progress := 10;
250: fnd_profile.get('MFG_ORGANIZATION_ID',org_id);
251: if org_id <> 0 then
252:
253: x_progress := 20;
254: select organization_name,