DBA Data[Home] [Help]

APPS.OZF_FORECAST_UTIL_PVT dependencies on FND_GLOBAL

Line 372: fnd_global.user_id , sysdate,

368: SENSITIVE_DATA_FLAG , METRIC_ID,
369: ORG_ID,
370: DIRTY_FLAG )
371: VALUES ( l_activity_metric_id , sysdate,
372: fnd_global.user_id , sysdate,
373: fnd_global.user_id , fnd_global.login_id,
374: 1 , l_forecast_id,
375: 'FCST' , 530 ,
376: 'N' , 1,

Line 373: fnd_global.user_id , fnd_global.login_id,

369: ORG_ID,
370: DIRTY_FLAG )
371: VALUES ( l_activity_metric_id , sysdate,
372: fnd_global.user_id , sysdate,
373: fnd_global.user_id , fnd_global.login_id,
374: 1 , l_forecast_id,
375: 'FCST' , 530 ,
376: 'N' , 1,
377: MO_GLOBAL.GET_CURRENT_ORG_ID() ,

Line 812: fnd_global.user_id,

808: l_qualifier_attr_value_to,
809: l_comparison_operator_code,
810: NULL,
811: sysdate,
812: fnd_global.user_id,
813: sysdate,
814: fnd_global.user_id,
815: fnd_global.login_id,
816: p_forecast_id );

Line 814: fnd_global.user_id,

810: NULL,
811: sysdate,
812: fnd_global.user_id,
813: sysdate,
814: fnd_global.user_id,
815: fnd_global.login_id,
816: p_forecast_id );
817:
818: END LOOP;

Line 815: fnd_global.login_id,

811: sysdate,
812: fnd_global.user_id,
813: sysdate,
814: fnd_global.user_id,
815: fnd_global.login_id,
816: p_forecast_id );
817:
818: END LOOP;
819:

Line 883: fnd_global.user_id,

879: l_product_attribute_e,
880: l_product_attr_value_e,
881: NULL,
882: sysdate,
883: fnd_global.user_id,
884: sysdate,
885: fnd_global.user_id,
886: fnd_global.login_id );
887:

Line 885: fnd_global.user_id,

881: NULL,
882: sysdate,
883: fnd_global.user_id,
884: sysdate,
885: fnd_global.user_id,
886: fnd_global.login_id );
887:
888:
889: END LOOP;

Line 886: fnd_global.login_id );

882: sysdate,
883: fnd_global.user_id,
884: sysdate,
885: fnd_global.user_id,
886: fnd_global.login_id );
887:
888:
889: END LOOP;
890:

Line 1074: FND_DSQL.add_text('fnd_global.user_id ,');

1070: FND_DSQL.add_bind(i.product_attr_value);
1071: FND_DSQL.add_text(',' );
1072: FND_DSQL.add_text('a.product_id , ');
1073: FND_DSQL.add_text('sysdate , ');
1074: FND_DSQL.add_text('fnd_global.user_id ,');
1075: FND_DSQL.add_text('sysdate , ');
1076: FND_DSQL.add_text('fnd_global.user_id, ');
1077: FND_DSQL.add_text('fnd_global.login_id ');
1078:

Line 1076: FND_DSQL.add_text('fnd_global.user_id, ');

1072: FND_DSQL.add_text('a.product_id , ');
1073: FND_DSQL.add_text('sysdate , ');
1074: FND_DSQL.add_text('fnd_global.user_id ,');
1075: FND_DSQL.add_text('sysdate , ');
1076: FND_DSQL.add_text('fnd_global.user_id, ');
1077: FND_DSQL.add_text('fnd_global.login_id ');
1078:
1079: FND_DSQL.add_text(' FROM (');
1080:

Line 1077: FND_DSQL.add_text('fnd_global.login_id ');

1073: FND_DSQL.add_text('sysdate , ');
1074: FND_DSQL.add_text('fnd_global.user_id ,');
1075: FND_DSQL.add_text('sysdate , ');
1076: FND_DSQL.add_text('fnd_global.user_id, ');
1077: FND_DSQL.add_text('fnd_global.login_id ');
1078:
1079: FND_DSQL.add_text(' FROM (');
1080:
1081: l_stmt_temp := null;

Line 1377: FND_DSQL.add_text('fnd_global.user_id ,');

1373: -- FND_DSQL.add_text(',');
1374: -- FND_DSQL.add_bind(l_site_use_code);
1375: -- FND_DSQL.add_text(',');
1376: FND_DSQL.add_text('sysdate , ');
1377: FND_DSQL.add_text('fnd_global.user_id ,');
1378: FND_DSQL.add_text('sysdate , ');
1379: FND_DSQL.add_text('fnd_global.user_id, ');
1380: FND_DSQL.add_text('fnd_global.login_id ');
1381:

Line 1379: FND_DSQL.add_text('fnd_global.user_id, ');

1375: -- FND_DSQL.add_text(',');
1376: FND_DSQL.add_text('sysdate , ');
1377: FND_DSQL.add_text('fnd_global.user_id ,');
1378: FND_DSQL.add_text('sysdate , ');
1379: FND_DSQL.add_text('fnd_global.user_id, ');
1380: FND_DSQL.add_text('fnd_global.login_id ');
1381:
1382: FND_DSQL.add_text(' FROM (');
1383:

Line 1380: FND_DSQL.add_text('fnd_global.login_id ');

1376: FND_DSQL.add_text('sysdate , ');
1377: FND_DSQL.add_text('fnd_global.user_id ,');
1378: FND_DSQL.add_text('sysdate , ');
1379: FND_DSQL.add_text('fnd_global.user_id, ');
1380: FND_DSQL.add_text('fnd_global.login_id ');
1381:
1382: FND_DSQL.add_text(' FROM (');
1383:
1384: OPEN c_no_qualifiers(i.qualifier_grouping_no);

Line 1636: fnd_global.user_id,

1632: l_period_number,
1633: l_temp_start_date,
1634: l_temp_end_date,
1635: sysdate,
1636: fnd_global.user_id,
1637: sysdate,
1638: fnd_global.user_id,
1639: fnd_global.login_id,
1640: l_period_type_id,

Line 1638: fnd_global.user_id,

1634: l_temp_end_date,
1635: sysdate,
1636: fnd_global.user_id,
1637: sysdate,
1638: fnd_global.user_id,
1639: fnd_global.login_id,
1640: l_period_type_id,
1641: l_name,
1642: p_forecast_id );

Line 1639: fnd_global.login_id,

1635: sysdate,
1636: fnd_global.user_id,
1637: sysdate,
1638: fnd_global.user_id,
1639: fnd_global.login_id,
1640: l_period_type_id,
1641: l_name,
1642: p_forecast_id );
1643: END LOOP;

Line 1696: fnd_global.user_id , sysdate ,

1692: PREVIOUS_FACT_ID , FACT_TYPE ,
1693: FACT_REFERENCE , LAST_UPDATE_LOGIN,
1694: FORECAST_REMAINING_QUANTITY , NODE_ID)
1695: VALUES ( ozf_act_metric_facts_all_s.nextval , sysdate ,
1696: fnd_global.user_id , sysdate ,
1697: fnd_global.user_id , 1 ,
1698: p_forecast_id , 'FCST' ,
1699: 'NUMERIC' , p_activity_metric_id,
1700: 0 , 'NONE',

Line 1697: fnd_global.user_id , 1 ,

1693: FACT_REFERENCE , LAST_UPDATE_LOGIN,
1694: FORECAST_REMAINING_QUANTITY , NODE_ID)
1695: VALUES ( ozf_act_metric_facts_all_s.nextval , sysdate ,
1696: fnd_global.user_id , sysdate ,
1697: fnd_global.user_id , 1 ,
1698: p_forecast_id , 'FCST' ,
1699: 'NUMERIC' , p_activity_metric_id,
1700: 0 , 'NONE',
1701: 0, MO_GLOBAL.GET_CURRENT_ORG_ID(),

Line 1707: p_fact_reference , fnd_global.login_id,

1703: p_start_date , p_end_date ,
1704: NULL , NULL ,
1705: ROUND(NVL(p_base_quantity,0)) , p_root_fact_id ,
1706: p_previous_fact_id , p_fact_type ,
1707: p_fact_reference , fnd_global.login_id,
1708: 0 , p_node_id);
1709:
1710: -- ROUND(NVL(p_base_quantity,0)) , p_root_fact_id ,
1711:

Line 5985: ,FND_GLOBAL.User_ID

5981: ,a.arc_act_fcast_used_by
5982: ,a.act_fcast_used_by_id
5983: ,SYSDATE
5984: ,a.created_from
5985: ,FND_GLOBAL.User_ID
5986: ,SYSDATE
5987: ,FND_GLOBAL.User_ID
5988: ,FND_GLOBAL.Conc_Login_ID
5989: ,a.program_application_id

Line 5987: ,FND_GLOBAL.User_ID

5983: ,SYSDATE
5984: ,a.created_from
5985: ,FND_GLOBAL.User_ID
5986: ,SYSDATE
5987: ,FND_GLOBAL.User_ID
5988: ,FND_GLOBAL.Conc_Login_ID
5989: ,a.program_application_id
5990: ,a.program_id
5991: ,a.program_update_date

Line 5988: ,FND_GLOBAL.Conc_Login_ID

5984: ,a.created_from
5985: ,FND_GLOBAL.User_ID
5986: ,SYSDATE
5987: ,FND_GLOBAL.User_ID
5988: ,FND_GLOBAL.Conc_Login_ID
5989: ,a.program_application_id
5990: ,a.program_id
5991: ,a.program_update_date
5992: ,a.request_id

Line 6106: Fnd_Global.User_ID,

6102: )
6103:
6104: SELECT l_activity_metric_id,
6105: SYSDATE,
6106: Fnd_Global.User_ID,
6107: SYSDATE,
6108: Fnd_Global.User_ID,
6109: Fnd_Global.Conc_Login_ID,
6110: 1, --Object Version Number

Line 6108: Fnd_Global.User_ID,

6104: SELECT l_activity_metric_id,
6105: SYSDATE,
6106: Fnd_Global.User_ID,
6107: SYSDATE,
6108: Fnd_Global.User_ID,
6109: Fnd_Global.Conc_Login_ID,
6110: 1, --Object Version Number
6111: l_forecast_id,
6112: b.arc_act_metric_used_by,

Line 6109: Fnd_Global.Conc_Login_ID,

6105: SYSDATE,
6106: Fnd_Global.User_ID,
6107: SYSDATE,
6108: Fnd_Global.User_ID,
6109: Fnd_Global.Conc_Login_ID,
6110: 1, --Object Version Number
6111: l_forecast_id,
6112: b.arc_act_metric_used_by,
6113: NVL(b.purchase_req_raised_flag,'N'),

Line 6226: Fnd_Global.User_ID,

6222: NODE_ID
6223: )
6224: VALUES ( l_act_metric_fact_id_level_1,
6225: SYSDATE,
6226: Fnd_Global.User_ID,
6227: SYSDATE,
6228: Fnd_Global.User_ID,
6229: 1,
6230: l_forecast_id,

Line 6228: Fnd_Global.User_ID,

6224: VALUES ( l_act_metric_fact_id_level_1,
6225: SYSDATE,
6226: Fnd_Global.User_ID,
6227: SYSDATE,
6228: Fnd_Global.User_ID,
6229: 1,
6230: l_forecast_id,
6231: 'FCST',
6232: 'NUMERIC',

Line 6249: fnd_global.login_id,

6245: level_one_fact_record.root_fact_id, -- will be NULL
6246: level_one_fact_record.previous_fact_id, -- will be NULL
6247: level_one_fact_record.fact_type,
6248: level_one_fact_record.fact_reference,
6249: fnd_global.login_id,
6250: level_one_fact_record.forecast_remaining_quantity,
6251: level_one_fact_record.forward_buy_quantity,
6252: level_one_fact_record.node_id
6253: );

Line 6301: Fnd_Global.User_ID,

6297: NODE_ID
6298: )
6299: VALUES ( l_act_metric_fact_id_level_2,
6300: SYSDATE,
6301: Fnd_Global.User_ID,
6302: SYSDATE,
6303: Fnd_Global.User_ID,
6304: 1,
6305: l_forecast_id,

Line 6303: Fnd_Global.User_ID,

6299: VALUES ( l_act_metric_fact_id_level_2,
6300: SYSDATE,
6301: Fnd_Global.User_ID,
6302: SYSDATE,
6303: Fnd_Global.User_ID,
6304: 1,
6305: l_forecast_id,
6306: 'FCST',
6307: 'NUMERIC',

Line 6324: fnd_global.login_id,

6320: level_two_fact_record.root_fact_id, -- will be NULL
6321: l_act_metric_fact_id_level_1, -- newly generated Level One activity_metric_fact_id
6322: level_two_fact_record.fact_type,
6323: level_two_fact_record.fact_reference,
6324: fnd_global.login_id,
6325: level_two_fact_record.forecast_remaining_quantity,
6326: level_two_fact_record.forward_buy_quantity,
6327: level_two_fact_record.node_id
6328: );

Line 6378: Fnd_Global.User_ID,

6374: NODE_ID
6375: )
6376: VALUES ( l_act_metric_fact_id_level_3,
6377: SYSDATE,
6378: Fnd_Global.User_ID,
6379: SYSDATE,
6380: Fnd_Global.User_ID,
6381: 1,
6382: l_forecast_id,

Line 6380: Fnd_Global.User_ID,

6376: VALUES ( l_act_metric_fact_id_level_3,
6377: SYSDATE,
6378: Fnd_Global.User_ID,
6379: SYSDATE,
6380: Fnd_Global.User_ID,
6381: 1,
6382: l_forecast_id,
6383: 'FCST',
6384: 'NUMERIC',

Line 6401: fnd_global.login_id,

6397: l_act_metric_fact_id_level_1, -- newly generated Level One activity_metric_fact_id
6398: l_act_metric_fact_id_level_2, -- newly generated Level Two activity_metric_fact_id
6399: level_three_fact_record.fact_type,
6400: level_three_fact_record.fact_reference,
6401: fnd_global.login_id,
6402: level_three_fact_record.forecast_remaining_quantity,
6403: level_three_fact_record.forward_buy_quantity,
6404: level_three_fact_record.node_id
6405: );