DBA Data[Home] [Help]

APPS.XDP_ORDER dependencies on FND_GLOBAL

Line 714: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

710:
711: update XDP_ORDER_HEADERS
712: set WF_ITEM_TYPE = lv_item_type,
713: WF_ITEM_KEY = lv_item_key,
714: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
715: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
716: where ORDER_ID = p_order_header.order_id;
717:
718:

Line 715: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

711: update XDP_ORDER_HEADERS
712: set WF_ITEM_TYPE = lv_item_type,
713: WF_ITEM_KEY = lv_item_key,
714: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
715: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
716: where ORDER_ID = p_order_header.order_id;
717:
718:
719:

Line 1991: fnd_global.user_id,

1987: p_order_header.ATTRIBUTE17,
1988: p_order_header.ATTRIBUTE18,
1989: p_order_header.ATTRIBUTE19,
1990: p_order_header.ATTRIBUTE20,
1991: fnd_global.user_id,
1992: sysdate,
1993: fnd_global.user_id,
1994: sysdate,
1995: fnd_global.login_id

Line 1993: fnd_global.user_id,

1989: p_order_header.ATTRIBUTE19,
1990: p_order_header.ATTRIBUTE20,
1991: fnd_global.user_id,
1992: sysdate,
1993: fnd_global.user_id,
1994: sysdate,
1995: fnd_global.login_id
1996: ) RETURNING ORDER_ID INTO P_order_header.order_id;
1997:

Line 1995: fnd_global.login_id

1991: fnd_global.user_id,
1992: sysdate,
1993: fnd_global.user_id,
1994: sysdate,
1995: fnd_global.login_id
1996: ) RETURNING ORDER_ID INTO P_order_header.order_id;
1997:
1998: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
1999: IF (FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, 'xdp.plsql.XDP_ORDER.POPULATE_ORDER_HEADER')) THEN

Line 2099: fnd_global.user_id,

2095: (
2096: p_order_header.order_id,
2097: lv_name_tab(lv_temp),
2098: lv_val_tab(lv_temp),
2099: fnd_global.user_id,
2100: sysdate,
2101: fnd_global.user_id,
2102: sysdate,
2103: fnd_global.login_id

Line 2101: fnd_global.user_id,

2097: lv_name_tab(lv_temp),
2098: lv_val_tab(lv_temp),
2099: fnd_global.user_id,
2100: sysdate,
2101: fnd_global.user_id,
2102: sysdate,
2103: fnd_global.login_id
2104: );
2105:

Line 2103: fnd_global.login_id

2099: fnd_global.user_id,
2100: sysdate,
2101: fnd_global.user_id,
2102: sysdate,
2103: fnd_global.login_id
2104: );
2105:
2106: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2107: IF (FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, 'xdp.plsql.XDP_ORDER.POPULATE_ORDER_HEADER')) THEN

Line 4054: ,fnd_global.user_id

4050: ,lv_attribute17_tab(lv_temp)
4051: ,lv_attribute18_tab(lv_temp)
4052: ,lv_attribute19_tab(lv_temp)
4053: ,lv_attribute20_tab(lv_temp)
4054: ,fnd_global.user_id
4055: ,sysdate
4056: ,fnd_global.user_id
4057: ,sysdate
4058: ,fnd_global.login_id

Line 4056: ,fnd_global.user_id

4052: ,lv_attribute19_tab(lv_temp)
4053: ,lv_attribute20_tab(lv_temp)
4054: ,fnd_global.user_id
4055: ,sysdate
4056: ,fnd_global.user_id
4057: ,sysdate
4058: ,fnd_global.login_id
4059: );
4060:

Line 4058: ,fnd_global.login_id

4054: ,fnd_global.user_id
4055: ,sysdate
4056: ,fnd_global.user_id
4057: ,sysdate
4058: ,fnd_global.login_id
4059: );
4060:
4061: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
4062: IF (FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, 'xdp.plsql.XDP_ORDER.POPULATE_LINES')) THEN

Line 4155: ,fnd_global.user_id

4151: (lv_line_item_id_tab(lv_temp)
4152: ,lv_rel_line_item_id_tab(lv_temp)
4153: ,lv_relationship_tab(lv_temp)
4154: ,sysdate
4155: ,fnd_global.user_id
4156: ,sysdate
4157: ,fnd_global.user_id
4158: ,fnd_global.login_id
4159: );

Line 4157: ,fnd_global.user_id

4153: ,lv_relationship_tab(lv_temp)
4154: ,sysdate
4155: ,fnd_global.user_id
4156: ,sysdate
4157: ,fnd_global.user_id
4158: ,fnd_global.login_id
4159: );
4160:
4161: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

Line 4158: ,fnd_global.login_id

4154: ,sysdate
4155: ,fnd_global.user_id
4156: ,sysdate
4157: ,fnd_global.user_id
4158: ,fnd_global.login_id
4159: );
4160:
4161: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
4162: IF (FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, 'xdp.plsql.XDP_ORDER.POPULATE_LINES')) THEN

Line 4250: fnd_global.user_id,

4246: (lv_line_item_id_tab(lv_temp),
4247: lv_name_tab(lv_temp),
4248: lv_val_tab(lv_temp),
4249: lv_ref_val_tab(lv_temp),
4250: fnd_global.user_id,
4251: sysdate,
4252: fnd_global.user_id,
4253: sysdate,
4254: fnd_global.login_id

Line 4252: fnd_global.user_id,

4248: lv_val_tab(lv_temp),
4249: lv_ref_val_tab(lv_temp),
4250: fnd_global.user_id,
4251: sysdate,
4252: fnd_global.user_id,
4253: sysdate,
4254: fnd_global.login_id
4255: );
4256:

Line 4254: fnd_global.login_id

4250: fnd_global.user_id,
4251: sysdate,
4252: fnd_global.user_id,
4253: sysdate,
4254: fnd_global.login_id
4255: );
4256:
4257: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
4258: IF (FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, 'xdp.plsql.XDP_ORDER.POPULATE_LINES')) THEN

Line 4886: FND_GLOBAL.USER_ID,

4882: l_attribute17_tab(l_index),
4883: l_attribute18_tab(l_index),
4884: l_attribute19_tab(l_index),
4885: l_attribute20_tab(l_index),
4886: FND_GLOBAL.USER_ID,
4887: SYSDATE,
4888: FND_GLOBAL.USER_ID,
4889: SYSDATE,
4890: FND_GLOBAL.LOGIN_ID

Line 4888: FND_GLOBAL.USER_ID,

4884: l_attribute19_tab(l_index),
4885: l_attribute20_tab(l_index),
4886: FND_GLOBAL.USER_ID,
4887: SYSDATE,
4888: FND_GLOBAL.USER_ID,
4889: SYSDATE,
4890: FND_GLOBAL.LOGIN_ID
4891: ) RETURNING workitem_instance_id BULK COLLECT INTO l_workitem_instance_id;
4892:

Line 4890: FND_GLOBAL.LOGIN_ID

4886: FND_GLOBAL.USER_ID,
4887: SYSDATE,
4888: FND_GLOBAL.USER_ID,
4889: SYSDATE,
4890: FND_GLOBAL.LOGIN_ID
4891: ) RETURNING workitem_instance_id BULK COLLECT INTO l_workitem_instance_id;
4892:
4893: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
4894: IF (FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, 'xdp.plsql.XDP_ORDER.POPULATE_LINES')) THEN

Line 5394: FND_GLOBAL.USER_ID,

5390: l_workitem_id(l_index),
5391: l_is_value_evaluated(l_index),
5392: l_parameter_value(l_index),
5393: l_parameter_ref_value(l_index),
5394: FND_GLOBAL.USER_ID,
5395: sysdate,
5396: FND_GLOBAL.USER_ID,
5397: sysdate,
5398: FND_GLOBAL.LOGIN_ID,

Line 5396: FND_GLOBAL.USER_ID,

5392: l_parameter_value(l_index),
5393: l_parameter_ref_value(l_index),
5394: FND_GLOBAL.USER_ID,
5395: sysdate,
5396: FND_GLOBAL.USER_ID,
5397: sysdate,
5398: FND_GLOBAL.LOGIN_ID,
5399: l_txn_attrib_detail_id(l_index),
5400: l_attrib_source_table(l_index),

Line 5398: FND_GLOBAL.LOGIN_ID,

5394: FND_GLOBAL.USER_ID,
5395: sysdate,
5396: FND_GLOBAL.USER_ID,
5397: sysdate,
5398: FND_GLOBAL.LOGIN_ID,
5399: l_txn_attrib_detail_id(l_index),
5400: l_attrib_source_table(l_index),
5401: l_attrib_source_id(l_index),
5402: l_modified_flag(l_index),

Line 5517: FND_GLOBAL.USER_ID,

5513: P_WORKITEM_EVAL_PARAM_LIST(i).workitem_id,
5514: P_WORKITEM_EVAL_PARAM_LIST(i).is_value_evaluated,
5515: P_WORKITEM_EVAL_PARAM_LIST(i).parameter_value,
5516: P_WORKITEM_EVAL_PARAM_LIST(i).parameter_ref_value,
5517: FND_GLOBAL.USER_ID,
5518: sysdate,
5519: FND_GLOBAL.USER_ID,
5520: sysdate,
5521: FND_GLOBAL.LOGIN_ID,

Line 5519: FND_GLOBAL.USER_ID,

5515: P_WORKITEM_EVAL_PARAM_LIST(i).parameter_value,
5516: P_WORKITEM_EVAL_PARAM_LIST(i).parameter_ref_value,
5517: FND_GLOBAL.USER_ID,
5518: sysdate,
5519: FND_GLOBAL.USER_ID,
5520: sysdate,
5521: FND_GLOBAL.LOGIN_ID,
5522: P_WORKITEM_EVAL_PARAM_LIST(i).txn_ext_attrib_detail_id,
5523: P_WORKITEM_EVAL_PARAM_LIST(i).attrib_source_table,

Line 5521: FND_GLOBAL.LOGIN_ID,

5517: FND_GLOBAL.USER_ID,
5518: sysdate,
5519: FND_GLOBAL.USER_ID,
5520: sysdate,
5521: FND_GLOBAL.LOGIN_ID,
5522: P_WORKITEM_EVAL_PARAM_LIST(i).txn_ext_attrib_detail_id,
5523: P_WORKITEM_EVAL_PARAM_LIST(i).attrib_source_table,
5524: P_WORKITEM_EVAL_PARAM_LIST(i).attrib_source_id,
5525: P_WORKITEM_EVAL_PARAM_LIST(i).modified_flag,