APPS.GML_PO_GLDIST dependencies on FND_PROFILE

Line 84: X_orgn_code := FND_PROFILE.VALUE ('GEMMS_DEFAULT_ORGN');

80: BEGIN
81: OPEN Cur_orgn_for_whse;
82: FETCH Cur_orgn_for_whse INTO X_orgn_code;
83: IF Cur_orgn_for_whse%NOTFOUND THEN
84: X_orgn_code := FND_PROFILE.VALUE ('GEMMS_DEFAULT_ORGN');
85: END IF;
86:
87: /* cmpntcls_id and analysis code comes for each row from the poglded2_process_trans. Hence, commented.*/
88: OPEN Cur_po_cost_mst ;

Line 272: X_orgn_code := FND_PROFILE.VALUE ('GEMMS_DEFAULT_ORGN');

268: BEGIN
269: OPEN Cur_orgn_for_whse;
270: FETCH Cur_orgn_for_whse INTO X_orgn_code;
271: IF Cur_orgn_for_whse%NOTFOUND THEN
272: X_orgn_code := FND_PROFILE.VALUE ('GEMMS_DEFAULT_ORGN');
273: END IF;
274: CLOSE Cur_orgn_for_whse;
275:
276: IF GML_PO_GLDIST.P_cost_cmpntcls_id IS NOT NULL AND GML_PO_GLDIST.P_cost_analysis_code IS NOT NULL THEN

Line 588: /* IF FND_PROFILE.VALUE ('GL$FINANCIAL_PACKAGE' ) = 'ORAFIN' THEN */

584: /*Sandeep. Code added to check, if 'GL$FINANCIAL_PACKAGE' is set to ORAFIN,*/
585: /* Then Fiscal Yr and Period values are fetched*/
586: /* from FINANCIAL Tables, else, fetched from GEMMS Tables.*/
587: /* B1297909 */
588: /* IF FND_PROFILE.VALUE ('GL$FINANCIAL_PACKAGE' ) = 'ORAFIN' THEN */
589: X_retval := GML_PO_GLDIST.get_orafin_sob (P_co_code, 0);
590: IF X_retval >= 0 THEN
591: /* GML_PO_GLDIST.P_period_date := P_po_date;*/
592: X_retval := GML_PO_GLDIST.get_ofperiod_info (P_co_code, 0,

Line 1013: X_created_by := FND_PROFILE.VALUE ('USER_ID');

1009: X_amount_trans := GML_PO_GLDIST.P_amount_trans_aqui;
1010: END IF;
1011:
1012: X_last_update_date := SYSDATE;
1013: X_created_by := FND_PROFILE.VALUE ('USER_ID');
1014: X_creation_date := SYSDATE;
1015: X_last_updated_by := FND_PROFILE.VALUE ('USER_ID');
1016: X_last_update_login := 0;
1017: X_trans_cnt := 0;

Line 1015: X_last_updated_by := FND_PROFILE.VALUE ('USER_ID');

1011:
1012: X_last_update_date := SYSDATE;
1013: X_created_by := FND_PROFILE.VALUE ('USER_ID');
1014: X_creation_date := SYSDATE;
1015: X_last_updated_by := FND_PROFILE.VALUE ('USER_ID');
1016: X_last_update_login := 0;
1017: X_trans_cnt := 0;
1018: X_text_code := NULL;
1019: X_delete_mark := 0;

Line 1327: x_default_orgn VARCHAR2(4) := FND_PROFILE.VALUE('SY$DEFAULT_ORGANIZATION');

1323: x_at_exp NUMBER DEFAULT 5100;
1324: x_at_aac NUMBER DEFAULT 3150;
1325: x_at_acv NUMBER DEFAULT 6150;
1326: x_at_erv NUMBER DEFAULT 5500;
1327: x_default_orgn VARCHAR2(4) := FND_PROFILE.VALUE('SY$DEFAULT_ORGANIZATION');
1328: x_cost_mthd VARCHAR2(10);
1329: x_cmpntcls_id NUMBER;
1330: x_analysis_code VARCHAR2(10);
1331: x_total_cost NUMBER;