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
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
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
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
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
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
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:
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;
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;
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:
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
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
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;
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;
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:
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:
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;
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;
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;
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) ;