DBA Data[Home] [Help]

APPS.POS_PRODUCT_SERVICE_UTL_PKG dependencies on FND_GLOBAL

Line 1024: fnd_global.user_id,

1020: null,
1021: null,
1022: flex_value_id,
1023: sysdate,
1024: fnd_global.user_id,
1025: fnd_global.login_id,
1026: sysdate,
1027: fnd_global.user_id
1028: FROM fnd_flex_values_vl

Line 1025: fnd_global.login_id,

1021: null,
1022: flex_value_id,
1023: sysdate,
1024: fnd_global.user_id,
1025: fnd_global.login_id,
1026: sysdate,
1027: fnd_global.user_id
1028: FROM fnd_flex_values_vl
1029: WHERE flex_value_set_id = p_curr_seg_val_id

Line 1027: fnd_global.user_id

1023: sysdate,
1024: fnd_global.user_id,
1025: fnd_global.login_id,
1026: sysdate,
1027: fnd_global.user_id
1028: FROM fnd_flex_values_vl
1029: WHERE flex_value_set_id = p_curr_seg_val_id
1030: and not exists (select SEGMENT_VALUE_ID
1031: from pos_products_services_gt

Line 1057: fnd_global.user_id,

1053: c1.flex_value_id,
1054: null,
1055: flex_value_id,
1056: sysdate,
1057: fnd_global.user_id,
1058: fnd_global.login_id,
1059: sysdate,
1060: fnd_global.user_id
1061: FROM fnd_flex_values_vl

Line 1058: fnd_global.login_id,

1054: null,
1055: flex_value_id,
1056: sysdate,
1057: fnd_global.user_id,
1058: fnd_global.login_id,
1059: sysdate,
1060: fnd_global.user_id
1061: FROM fnd_flex_values_vl
1062: WHERE flex_value_set_id = p_curr_seg_val_id and

Line 1060: fnd_global.user_id

1056: sysdate,
1057: fnd_global.user_id,
1058: fnd_global.login_id,
1059: sysdate,
1060: fnd_global.user_id
1061: FROM fnd_flex_values_vl
1062: WHERE flex_value_set_id = p_curr_seg_val_id and
1063: parent_flex_value_low = c1.flex_value and
1064: not exists (select SEGMENT_VALUE_ID

Line 1108: fnd_global.user_id,

1104: null,
1105: null,
1106: l_value,
1107: sysdate,
1108: fnd_global.user_id,
1109: fnd_global.login_id,
1110: sysdate,
1111: fnd_global.user_id);
1112:

Line 1109: fnd_global.login_id,

1105: null,
1106: l_value,
1107: sysdate,
1108: fnd_global.user_id,
1109: fnd_global.login_id,
1110: sysdate,
1111: fnd_global.user_id);
1112:
1113: end loop;

Line 1111: fnd_global.user_id);

1107: sysdate,
1108: fnd_global.user_id,
1109: fnd_global.login_id,
1110: sysdate,
1111: fnd_global.user_id);
1112:
1113: end loop;
1114: CLOSE l_tblcur;
1115: end if;

Line 1583: fnd_global.user_id, sysdate,

1579: )
1580: VALUES
1581: (
1582: pos_supplier_mapping_s.nextval, l_party_id, p_vendor_id,
1583: fnd_global.user_id, sysdate,
1584: fnd_global.user_id, sysdate, fnd_global.login_id
1585: );
1586: END IF;
1587:

Line 1584: fnd_global.user_id, sysdate, fnd_global.login_id

1580: VALUES
1581: (
1582: pos_supplier_mapping_s.nextval, l_party_id, p_vendor_id,
1583: fnd_global.user_id, sysdate,
1584: fnd_global.user_id, sysdate, fnd_global.login_id
1585: );
1586: END IF;
1587:
1588: select mapping_id

Line 1653: , fnd_global.user_id

1649: , p_segment20
1650: , 'PENDING'
1651: , 'ADD'
1652: , p_segment_definition
1653: , fnd_global.user_id
1654: , Sysdate
1655: , fnd_global.user_id
1656: , Sysdate
1657: , fnd_global.login_id

Line 1655: , fnd_global.user_id

1651: , 'ADD'
1652: , p_segment_definition
1653: , fnd_global.user_id
1654: , Sysdate
1655: , fnd_global.user_id
1656: , Sysdate
1657: , fnd_global.login_id
1658: );
1659: x_return_status := fnd_api.g_ret_sts_success;

Line 1657: , fnd_global.login_id

1653: , fnd_global.user_id
1654: , Sysdate
1655: , fnd_global.user_id
1656: , Sysdate
1657: , fnd_global.login_id
1658: );
1659: x_return_status := fnd_api.g_ret_sts_success;
1660:
1661: end add_new_ps_req;

Line 1677: last_updated_by = fnd_global.user_id,

1673: for i in 1..p_req_id_tbl.COUNT LOOP
1674:
1675: UPDATE POS_SUP_PRODUCTS_SERVICES
1676: SET status = p_status,
1677: last_updated_by = fnd_global.user_id,
1678: last_update_date = Sysdate,
1679: last_update_login = fnd_global.login_id
1680: WHERE classification_id = p_req_id_tbl(i);
1681:

Line 1679: last_update_login = fnd_global.login_id

1675: UPDATE POS_SUP_PRODUCTS_SERVICES
1676: SET status = p_status,
1677: last_updated_by = fnd_global.user_id,
1678: last_update_date = Sysdate,
1679: last_update_login = fnd_global.login_id
1680: WHERE classification_id = p_req_id_tbl(i);
1681:
1682: END LOOP;
1683:

Line 1700: last_updated_by = fnd_global.user_id,

1696:
1697: for i in 1..p_req_id_tbl.COUNT LOOP
1698: UPDATE POS_PRODUCT_SERVICE_REQUESTS
1699: SET request_status = 'DELETED',
1700: last_updated_by = fnd_global.user_id,
1701: last_update_date = Sysdate,
1702: last_update_login = fnd_global.login_id
1703: WHERE PS_REQUEST_ID = p_req_id_tbl(i);
1704: END LOOP;

Line 1702: last_update_login = fnd_global.login_id

1698: UPDATE POS_PRODUCT_SERVICE_REQUESTS
1699: SET request_status = 'DELETED',
1700: last_updated_by = fnd_global.user_id,
1701: last_update_date = Sysdate,
1702: last_update_login = fnd_global.login_id
1703: WHERE PS_REQUEST_ID = p_req_id_tbl(i);
1704: END LOOP;
1705:
1706: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1722: last_updated_by = fnd_global.user_id,

1718: for i in 1..p_req_id_tbl.COUNT LOOP
1719: UPDATE POS_PRODUCT_SERVICE_REQUESTS
1720: SET request_status = 'PENDING',
1721: request_type = 'ADD',
1722: last_updated_by = fnd_global.user_id,
1723: last_update_date = Sysdate,
1724: last_update_login = fnd_global.login_id
1725: WHERE PS_REQUEST_ID = p_req_id_tbl(i);
1726: END LOOP;

Line 1724: last_update_login = fnd_global.login_id

1720: SET request_status = 'PENDING',
1721: request_type = 'ADD',
1722: last_updated_by = fnd_global.user_id,
1723: last_update_date = Sysdate,
1724: last_update_login = fnd_global.login_id
1725: WHERE PS_REQUEST_ID = p_req_id_tbl(i);
1726: END LOOP;
1727:
1728: pos_profile_change_request_pkg.approve_mult_ps_reqs( p_req_id_tbl, x_return_status, x_msg_count, x_msg_data) ;